Disable calculate formulas that link to other files

Aleventura

New Member
Joined
Oct 21, 2011
Messages
3
Hello to all, I have searched for this a lot and haven’t been able to find a solution. I would be very grateful if some of you could help me:
I got a workbook that is linked to many external workbooks and it is very slow to calculate, so I work it with manual calculation and only calculate the sheet (SHIFT+F9) when necessary. To work with this workbook I need to be able to make faster manual calculations.
I have tried many solutions and the only one that seems to work, is to work without the links to the other files (by breaking the links and turning the formulas to values). The problem with this solution is that I can’t lose the formulas.
I think that must be a way to calculate the sheet without calculating the cells that got a reference to the external files. Only the formulas in the current sheet.

Thank you very much.
Alejandro (from Chile)
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
You would be better off seeing if you can improve the linking formulas ... give examples of the external formulas in your book.

How many files are linked to your book? Is it practical to have those books open when you recalculate?
 
Upvote 0
Mostly are countif, sumif, vlookup, etc. These files must be external because they are filled by other persons. The files must be open, otherwise they are turned into #VALUE that ruin the calculations. I have try to optimize the calculation, buy there are too many rows.

Alejandro
 
Upvote 0
Can you show the actual COUNTIF SUMIF or VLOOKUP formulas? I'd like to see whether you are doing something nasty with the referenced ranges, like referencing entire columns, maybe?
 
Upvote 0

Forum statistics

Threads
1,203,522
Messages
6,055,893
Members
444,832
Latest member
Kauri

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