Not sure if this will help, but does setting Calculation to Manual before making the changes make a difference?
Not sure if this will help, but does setting Calculation to Manual before making the changes make a difference?
Thanks, Paul, for your response, but I already have it on manual calculate. Still, whenever the formula in each cell tries to pull the value from an external workbook, the file prompt opens even though I already have the correct file path in the formula. If this only happened once or twice it wouldn't be big deal, but I copy these formulas over for each month, and their must be at least 100 instances each month.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks