Is there anyway to have Excel not put the path in a formula when renaming a
file. I have some large long IF statements in my workbook and when I save
the file in a different directory and then try to reopen, I get a "formula is
too long" error. These functions are linked to other spreadsheets on
different drives. Can someone please help?