How can I change the formula for multiple cells at once?
Another way is to go to HomeFind and SelectReplace...
Where you find the reference to the old spreadsheet between the  brackets,
place all of that (including the  brackets) into the FIND WHAT box, in the
REPLACE WITH box, place the new target. Select Replace All.
I am copying a sheet from one workbook to another
This sheet is filled with formulas
When i place it in the new location, the formulas are all in place, but they
make calculations based on the workbook they came from rather than the new one
I can make the needed adjustments and get the correct calculations in the
formulas, but i have to do this for each cell
There are 5040 cells
Is there a way to do multiple cells at one time?