Document not saved problem

  • Thread starter Thread starter Roy
  • Start date Start date
R

Roy

This is probably simple, but it sure has me stumped. I created a workbook by
moving 11 different Excel files into a single workbook. Each file occupies a
single sheet in the workbook. When I go to save the new workbook it gives a
message "Document not saved". No other information. No matter what I do I
cannot save the new workbook. Any ideas why? I really need to create this
single workbook from multiple files.
Roy
 
Do you have permission to save to the folder you're using?
Any interference with your Antivirus software? (disable it and try again).
Is there space on your drive for the new file?

Are you saving to a network drive? (Maybe it's having trouble and is
temporarily disconnected??)
 
Thanks for the suggestions. Unfortunately none of these are an issue. There
is plenty of space and it is a local drive (over 80GB free), turning off
anti-virus made no difference, and I am working as the admin on this
machine. If it helps I am using Windows XP and Office XP. Each is up to
date. Any other ideas?
 
Just a wild one.

Any chance that there's a macro hanging around? I would be money that this
guess is wrong--but maybe...

And one more: What's the name of the file you're trying to save? Maybe you're
using an invalid name.

But I think both of these are doomed to failure.

Sorry,
 
Just kind of solved it. When creating the new workbook I moved each of the
individual sheets. I tried it again (about the 10th try) and this time
checked the box to make a copy of each sheet as it was moved to the new
workbook. For some reason this worked. I was able to save the new workbook.
Not sure why, but this is my new approach. After creating the new workbook
and saving it I just go delete each of the individual worksheet copies.
Roy
 
Back
Top