Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Document Not Saved Error
I've recently created a timesheet spreadsheet (half a MB in size) with thirteen worksheets. I have extensive vba code in it. Excell 2000.
When run on a local hard drive, it runs flawlessly. When run through a 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 it will run perfectly next time you open it. There are about 18 of these spreadsheets in a single network directory (18 users), with an aggregate size of about 9MB. Some people have no 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 of network connection since this never happens with any other excel spreadsheet (with VBA or not). In fact, when this occured once I had another spreadsheet open over the network at the same time, with no problems. I've tried Microsofts 'network resiliency' workaround, but it still happens. Any advice would be greatly appreciated! Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Document Not Saved Error
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 PanelsAdd 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 On Thu, 31 Jan 2008 23:18:09 +0000, Otivexcel wrote: I've recently created a timesheet spreadsheet (half a MB in size) with thirteen worksheets. I have extensive vba code in it. Excell 2000. When run on a local hard drive, it runs flawlessly. When run through a 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 it will run perfectly next time you open it. There are about 18 of these spreadsheets in a single network directory (18 users), with an aggregate size of about 9MB. Some people have no 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 of network connection since this never happens with any other excel spreadsheet (with VBA or not). In fact, when this occured once I had another spreadsheet open over the network at the same time, with no problems. I've tried Microsofts 'network resiliency' workaround, but it still happens. Any advice would be greatly appreciated! Thanks! |
#3
|
|||
|
|||
Thanks Gord. I've never seen the "file isn't accessible" error (at 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've already been there <sigh Much appreciated. Quote:
|
#4
|
|||
|
|||
...oh...and yes, it is a network drive. This is the only file it happens on. All other excel and office files over the network work flawlessly.
|
#5
|
|||
|
|||
In reviewing some of the posts from Gord's link, I came across one user who suspected that certain 'change events' were the root of the 'Document Not Saved' problem. His theory was that the file couldn't save if there was some kind of active VB code still running for some reason.
My spreadsheet has some worksheet change events as well and the solution sounds plasible. The code suggested by the post, which effective 'resets' any running VB module as follows: Application.VBE.CommandBars.FindControl(ID:=228).E xecute DoEvents I'm thinking of inserting this code in the 'before save' event to reset any code still running. To be extra safe, I was also thinking of seting 'application events' to false before closing, and have it set back to 'true' when opening. Does this sound plausible to any of the Gurus? Thanks |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Document Not Saved Error
Wish I could have helped.
Did you check out the google search results? Gord On Fri, 1 Feb 2008 20:21:42 +0000, Otivexcel wrote: Thanks Gord. I've never seen the "file isn't accessible" error (at 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've already been there <sigh Much appreciated. Gord Dibben;620894 Wrote: 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 PanelsAdd 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 On Thu, 31 Jan 2008 23:18:09 +0000, Otivexcel wrote: - I've recently created a timesheet spreadsheet (half a MB in size) with thirteen worksheets. I have extensive vba code in it. Excell 2000. When run on a local hard drive, it runs flawlessly. When run through a 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 it will run perfectly next time you open it. There are about 18 of these spreadsheets in a single network directory (18 users), with an aggregate size of about 9MB. Some people have no 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 of network connection since this never happens with any other excel spreadsheet (with VBA or not). In fact, when this occured once I had another spreadsheet open over the network at the same time, with no problems. I've tried Microsofts 'network resiliency' workaround, but it still happens. Any advice would be greatly appreciated! Thanks!- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Document not saved | Excel Discussion (Misc queries) | |||
Excel document was saved to word in error how do I get it back | Excel Discussion (Misc queries) | |||
Why do I get an error Document not Saved in Excel? | Excel Discussion (Misc queries) | |||
Document Not Saved Error Message - Excel 2003 | Excel Discussion (Misc queries) | |||
ERROR MESSAGE DOCUMENT NOT SAVED | Excel Discussion (Misc queries) |