speed up excel

karwanbk

New Member
Joined
Jul 20, 2017
Messages
21
hello,

i have a an excel file with lot of sheet's and formulas when i add data it make calculation slower :(

and i have "Calculating: (4 Processor(s)): %" at the bottom right of the workbook?
if i opened this excel file on another computer with higher model and faster should the the excel calculation be faster or i should change options in my excel file ?

thanks
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
Consider whether you need so many Formulas or if you can simply copy and "paste values" over the formulas. You can also set your "Calculation Options" to "Manual" and only calculate when needed.

Try reducing needless data. A horse can carry a cinder block better than a cat(Your faster computer question), that doesn't mean you should pack around unnecessary weight.

In the end: Put your workbook on a diet.
 
Upvote 0
This tells us nothing

Code:
an excel file with lot of sheet's and formulas


How many sheets, what type of formulas ???
Do you have any macros running ?
How much data are you adding....1 cell, 1 row ??
 
Upvote 0

Forum statistics

Threads
1,223,907
Messages
6,175,300
Members
452,633
Latest member
DougMo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top