Copying formulas to a different file without path in the formula?
 

I am trying to copy a whole page that contains formulas to another file. The
formulas in the other file end up with the path from the original file. Is
there a way to get around this?

Copying formulas to a different file without path in the formula?
 

The easiest way that I've used is find and replace all. If you leave
the "replace all" box blank, it will do just that in the replacement.
That will make the formulas reference the current file you're in.
Hope that helps.
Phillycheese5


--
Phillycheese5
------------------------------------------------------------------------
Phillycheese5's Profile: http://www.excelforum.com/member.php...o&userid=24196
View this thread: http://www.excelforum.com/showthread...hreadid=498442