Hello!
I have a rather large excel file which is linked to by mutliuple smaller files. I need to recalculate the large file, open smaller file - save smaller file and then recalculate the large file and so on....
I wanted to ask if it is possible to temporarily stop the calculation of a large file when I perform a macro on a small file??
The macro on a small file runs much faster when the large file is not open....can I just make excel ignore the large file?
Thanks!!