|
|
|
|
Yes I did Gord, thank you. I did get food for thought from one of the posts on google involving change events....I'm going to try this out on Monday.
Thanks again.
Quote:
Originally Posted by Gord Dibben
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!- |
|
Similar Threads
Threaded Mode
