ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Losing formula references to other sheets - HELP! (https://www.excelbanter.com/excel-worksheet-functions/211452-losing-formula-references-other-sheets-help.html)

Robert_L_Ross

Losing formula references to other sheets - HELP!
 
I have a spreadsheet that has dozens of references to other sheets in the
formulas...like so:

=IF(OR(ISNA(VLOOKUP("SLATE",'G:\GS_Secure\REPORTS\ Monthly\HiPath\USER_SUMMARY\10\[USER_Summary.xlsx]USER_SUMMARY'!$A$9:$D$12,2,FALSE)),ISBLANK(VLOOKUP ("SLATE",'G:\GS_Secure\REPORTS\Monthly\HiPath\USER _SUMMARY\10\[USER_Summary.xlsx]USER_SUMMARY'!$A$9:$D$12,2,FALSE))),"",VLOOKUP("SL ATE",'G:\GS_Secure\REPORTS\Monthly\HiPath\USER_SUM MARY\10\[USER_Summary.xlsx]USER_SUMMARY'!$A$9:$D$12,2,FALSE))

When I save the workbook and re-open, the formulas change like so:

=IF(OR(ISNA(VLOOKUP("SLATE",'C:\Documents and Settings\RRoss\Application
Data\Microsoft\Excel\HiPath\USER_SUMMARY\10\[USER_Summary.xlsx]USER_SUMMARY'!$A$9:$D$12,2,FALSE)),ISBLANK(VLOOKUP ("SLATE",'C:\Documents
and Settings\RRoss\Application
Data\Microsoft\Excel\HiPath\USER_SUMMARY\10\[USER_Summary.xlsx]USER_SUMMARY'!$A$9:$D$12,2,FALSE))),"",VLOOKUP("SL ATE",'C:\Documents
and Settings\RRoss\Application
Data\Microsoft\Excel\HiPath\USER_SUMMARY\10\[USER_Summary.xlsx]USER_SUMMARY'!$A$9:$D$12,2,FALSE))

What is causing this and how do I stop it? This never happened in the old
version (XP) of Excel, but this new 2007 does it all the time.

Thanks!


All times are GMT +1. The time now is 07:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com