Opening files saved to CD give wrong drive reference

  • Thread starter Thread starter Jean Chang
  • Start date Start date
J

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
 
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)
 
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
 
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.
 
Back
Top