Problem with my formulas

M

maurices5000

I simply placed an equal sign in a cell and clicked the worksheet i
wanted to reference. When i first created this worksheet everything
worked fine. But now, over time, it has generated this:

='C:\Documents and Settings\FPHC\Desktop\Open Projects\Electronic Daily
Encounter Balance Sheets (eDEBS)\Day Clinic\A-B\Adult Medicine\Mazumder,
Seba\[May 2006 Daily Encounter Balance Sheet.xls]Week 1'!M6

The problem with this is that it causes problems when i'm cutting and
pasting.

Now when i try to do it again by placing an equal sign in the cell and
clicking the cell i want to reference, it gives me "#VALUE!" in this
cell.

How can i prevent this from happening in the future? Or what is going
on? thanks!
 
H

Harlan Grove

maurices5000 wrote...
I simply placed an equal sign in a cell and clicked the worksheet i
wanted to reference. When i first created this worksheet everything
worked fine. But now, over time, it has generated this:

='C:\Documents and Settings\FPHC\Desktop\Open Projects\Electronic Daily
Encounter Balance Sheets (eDEBS)\Day Clinic\A-B\Adult Medicine\Mazumder,
Seba\[May 2006 Daily Encounter Balance Sheet.xls]Week 1'!M6
Click to expand...

Presumably when you first created this formula it looked like

='[May 2006 Daily Encounter Balance Sheet.xls]Week 1'!M6

which is what it should look like when the workbook file named 'May
2006 Daily Encounter Balance Sheet.xls' is open. However, when you
close Excel workbooks, Excel adds the full drive/directory path to the
base filename in any references to that workbook in any formulas in the
remaining open workbooks.
The problem with this is that it causes problems when i'm cutting and
pasting.
Click to expand...

What problems PRECISELY?
Now when i try to do it again by placing an equal sign in the cell and
clicking the cell i want to reference, it gives me "#VALUE!" in this
cell.
Click to expand...

What does the new formula look like?
How can i prevent this from happening in the future? Or what is going
on? thanks!
Click to expand...

Explained above what's going on. No way to change it. This is just how
Excel works.
 
Top