Microsoft Office 2007 home and student

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.

Thanks,

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 - ...you can guess the rest.

Thank you for the clarification. I hate assuming things. Regards,

Ask Your Question

Weekly Poll