Saving workbook(s) changes formula

Microsoft Office 2007 home and student
August 23, 2010 at 09:18:12
Specs: Windows Vista
I have two workbooks that work together. One pulls information from the other.

The formulas that I have entered in the workbook change when I copy the book(s) or email them. When I check the formulas, I now see file paths listed.

My concern is that it may alter the efficiency of the workbook(s) and make problem solving with formulas difficult.

I will be sending these to someone else to work on periodically, and then they will be returned to me with more information in them.

Will this be affected?

I have never noticed this before, so am not sure if it is normal, etc.

Any direction/help/confirmation would be greatly appreciated.


See More: Saving workbook(s) changes formula

Report •

August 23, 2010 at 09:52:32
If the referenced workbook is open on the same system as the workbook that is referencing it, the path will not be shown.

If the referenced workbook is closed - or not available on the system that is referencing it - can guess the rest.

Report •

August 24, 2010 at 06:10:53
Thank you for the clarification. I hate assuming things.


Report •

Related Solutions

Ask Question