Opening files saved to CD give wrong drive reference

[Jean Chang]

I have 7 multi-page excel files for my budget. I created
them all on my home computer. They are all linked with
formulas. I saved all of the files to a CD using Easy CD
Creator. Then I took the CD to work so I can work on the
budget there. No matter how I try to get the files onto
my C drive, when I open the spreadsheets, wherever a
formula references another worksheet, it shows the path
to the CD drive instead of the file I copies onto the C
drive, so if I remove the disk, I can't use the
spreadsheets on my work computer. Any help on what I'm
doing wrong will be really appreciated.
Thanks,
Jean Chang

 

[jaf]

Hi Jean,
You should never write file to a CD or floppy from Excel (or any other
program). Write to the HD and the copy to the CD with explorer or your CD
burning s/w.

Then copy it to the other machines HD and reset the read only property it
gets from the CD.
(in explorer, right click > properties uncheck read only)

 

[Jean Chang]

Hi,
Thanks for answering. I didn't write the files directly
from excel. They were already on my hard drive. I used EZ
CD creator to burn from the C drive onto the CD. Then I
took the CD to work. So if I chang the read only property
will that do it? Thanks again.
Jean

 

[jaf]

Hi Jean,
The read only property will prevent you saving the file back to disk.

No idea why the links should be changing.

You can try edit>links and change the drive letter.