Losing formula references to other sheets - HELP!

R

Robert_L_Ross

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("SLATE",'G:\GS_Secure\REPORTS\Monthly\HiPath\USER_SUMMARY\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("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))

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

INDIRECT should be updated to work on closed workbooks. 0
Mapping strings to integers 6
The code below worked for a few days and just totally stoppedworking. 1
Can someone please tell me why my code stopped working??? 1
vlookup or index/match formula?? 2
VLOOKUP 7
Nested Formulas v Named Formulas Any other solutions? 10
Calculating the Count of Monthly Gains/Losses 3

Top