Document Not Saved Error

[Otivexcel]

I've recently created a timesheet spreadsheet (half a MB in size) wit
thirteen worksheets. I have extensive vba code in it. Excell 2000.

When run on a local hard drive, it runs flawlessly. When run through
network drive it intermintently produces a 'document not saved' error
where you can't save, nor 'save as' even to another (local) directory.
Often, you can close without saving (because you have no choice) and i
will run perfectly next time you open it.

There are about 18 of these spreadsheets in a single network director
(18 users), with an aggregate size of about 9MB. Some people have n
problems, while others (including me) get this error intermitently.

There is plenty of space on the server and I don't think it's a loss o
network connection since this never happens with any other exce
spreadsheet (with VBA or not). In fact, when this occured once I ha
another spreadsheet open over the network at the same time, with n
problems.

I've tried Microsofts 'network resiliency' workaround, but it stil
happens.

Any advice would be greatly appreciated! Thanks

 

[Gord Dibben]

Are you on a network and message reads....

"file isn't accessible
unavailable volume or invalid password."

If so..........

Reports indicate the issue is caused by Windows XP update Q885250.

Uninstalling it appears to resolve the problem.

To uninstall Q885250 go to Control Panels>Add Remove and click on "Show
Updates".

Scroll to Q885250 and uninstall it.

If not the above............

Check out these threads about "document not saved" on google.

http://snipurl.com/d7fr


Gord Dibben Excel MVP

 

[Otivexcel]

Thanks Gord. I've never seen the "file isn't accessible" error (a
least I have that going for me). It's just the "Document Not Saved
error only.

I'll check out the link you've given, but something tells me I'v
already been there <sigh>

Much appreciated.

 

[Gord Dibben]

Wish I could have helped.

Did you check out the google search results?


Gord

 

[Otivexcel]

Yes I did Gord, thank you. I did get food for thought from one of th
posts on google involving change events....I'm going to try this out o
Monday.

Thanks again.

 

[Otivexcel]

Nope, my theory of two posts ago did not work. I'm at the end of m
rope. Just can't understand why the spreadsheet works flawlessly o
local drive and only sometimes on network.

Oh well, time to dump excel for this project...just too unreliable.

 

[Otivexcel]

After a long time of pulling my hair out over this 'document not saved'
problem, I may be on to something and wanted to bounce it off the
experts.

I noticed that sometimes when I get this error, my 'Module1' macros
were not showing (or deleted) in the VBA editor. I moved all
procedures from Module1 to the 'Thisworkbook' module and then deleted
Module1. Maybe virus program deleting Module1.

Since I've done this, I haven't been able to replicate the error.

Does this sound plausible?

 

[Otivexcel]

Well, after much heartache, it appears we found the source of the
problem. My excel file with vba code in it often gave a 'Document not
saved' error when run/saved on a network drive. It didn't produce this
error on a local drive.

The network drive in question was part of a RAID disk system
(apparently this stands for Redundant Array of Inexpensive Disks). I
am told that this disk system is not the on the actual server, but is
run through the server.

Long story short, when the excel files in question were moved directly
to the server's hard drive, the problem as gone. There is obviously
some kind of conflict with excel/vba and the RAID disk setup.

While this is not a resolution (since we still don't know why we can
use the RAID disks), we've moved the files to a direct location on the
server and are now able to run the excel files normally.

Hope that helps someone out there. If anyone has discovered a solution
for the RAID system, I'd love to know.

Thanks