Disable calculate formulas that link to other files

[Aleventura]

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)

 

[GlennUK]

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?

 

[Aleventura]

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

 

[GlennUK]

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?