references

nancyo · May 23rd, 2002, 01:46 PM

Maybe I am just tired...I am adding some formulas to spreadsheets which reference other worksheets in the same file. I have done this many times.

When I hit enter, a warning comes up that the file is not found????

I have compared the formulas to other IDENTICAL formulas in other files, and cannot find any mistakes.

I have to move on for now, but was wondering if anyone knew what this means? Time to go home, maybe??

texasalynn · May 23rd, 2002, 02:46 PM

Could it be the file was accidentally moved? If it is on a shared network drive that happens sometimes or maybe it was renamed. I would check those first.

nancyo · May 23rd, 2002, 02:53 PM

Let me try to be a little more clear, sorry -I am not even trying to save the file, I am just trying to reference another worksheet and it is acting like the worksheet isn't there, I guess...

texasalynn · May 23rd, 2002, 03:29 PM

Yes - but that could still be the issue! Go to your Windows Explorer and look for the other referenced workbooks.

texasalynn · May 23rd, 2002, 03:31 PM

OOPS - sorry I was thinking of other files but you clearly said worksheets within the same file! Not the issue. Are the reference names spelled correctly or are you actually going to the reference point and clicking it?

sen_edp · May 23rd, 2002, 03:35 PM

hello Nancy

Did you try to copy-paste special-paste link, between 2 worksheets .
does this works ?

nancyo · May 24th, 2002, 07:03 AM

I figured it out...I was trying to reference worksheet tabs, and for some reason, if I try to include the tab name in a formula, there cannot be any spaces between the name on the tab;

i.e. Day1SUM cannot be DAY 1 SUM

I renamed all the tabs and there doesn't seem to be any issues. I knew this from a while ago, and apparently forgot.

THANKS TO ALL!!

May 23rd, 2002, 03:35 PM	#6
sen_edp Board Regular Join Date: Mar 2002 Location: Hellas Posts: 553	hello Nancy Did you try to copy-paste special-paste link, between 2 worksheets . does this works ? __________________ Best Regards Andreas

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 23rd, 2002, 01:46 PM	#1
nancyo Board Regular Join Date: Mar 2002 Location: Massachusetts, USA Posts: 255	Maybe I am just tired...I am adding some formulas to spreadsheets which reference other worksheets in the same file. I have done this many times. When I hit enter, a warning comes up that the file is not found???? I have compared the formulas to other IDENTICAL formulas in other files, and cannot find any mistakes. I have to move on for now, but was wondering if anyone knew what this means? Time to go home, maybe??

May 23rd, 2002, 02:46 PM	#2
texasalynn Board Regular Join Date: May 2002 Location: Houston, TX Posts: 7,184	Could it be the file was accidentally moved? If it is on a shared network drive that happens sometimes or maybe it was renamed. I would check those first.

May 23rd, 2002, 02:53 PM	#3
nancyo Board Regular Join Date: Mar 2002 Location: Massachusetts, USA Posts: 255	Let me try to be a little more clear, sorry -I am not even trying to save the file, I am just trying to reference another worksheet and it is acting like the worksheet isn't there, I guess...

May 23rd, 2002, 03:29 PM	#4
texasalynn Board Regular Join Date: May 2002 Location: Houston, TX Posts: 7,184	Yes - but that could still be the issue! Go to your Windows Explorer and look for the other referenced workbooks.

May 23rd, 2002, 03:31 PM	#5
texasalynn Board Regular Join Date: May 2002 Location: Houston, TX Posts: 7,184	OOPS - sorry I was thinking of other files but you clearly said worksheets within the same file! Not the issue. Are the reference names spelled correctly or are you actually going to the reference point and clicking it?

May 24th, 2002, 07:03 AM	#7
nancyo Board Regular Join Date: Mar 2002 Location: Massachusetts, USA Posts: 255	I figured it out...I was trying to reference worksheet tabs, and for some reason, if I try to include the tab name in a formula, there cannot be any spaces between the name on the tab; i.e. Day1SUM cannot be DAY 1 SUM I renamed all the tabs and there doesn't seem to be any issues. I knew this from a while ago, and apparently forgot. THANKS TO ALL!!