Access denied on save *sometimes*

A

Aaron C

Hello all. I was hoping you could give me some help on this.

I have a huge file (Excel 2007 format, 9 sheets, at least 4 of which
have 4 columns by 100,000+ rows, Vlookups, if/thens, tons of stuff.
file size is over 25MB. HUGE.) saved on a network drive (required by
my work). About half of the time when I hit the "save" button, it
saves to what I must assume is a temp file, then copies that over to
the network drive ("Saving" progress bar, then a box which pops up and
has a progress bar and the word "Saving"), and then pops up a message
box with "Access denied. Contact your administrator.". My
administrator has no clue, except to say that it's probably excel
having some sort of issue saving to the network. The part that REALLY
bothers me is that it's only about half of the time. I could
understand if it were EVERY time, but can't figure out half.

Any ideas? Known bug, to be fixed in SP1?

Any help you could give would be wonderful. Thanks,
 
B

Bruce Sinclair

Hello all. I was hoping you could give me some help on this.

I have a huge file (Excel 2007 format, 9 sheets, at least 4 of which
have 4 columns by 100,000+ rows, Vlookups, if/thens, tons of stuff.
file size is over 25MB. HUGE.) saved on a network drive (required by
my work). About half of the time when I hit the "save" button, it
saves to what I must assume is a temp file, then copies that over to
the network drive ("Saving" progress bar, then a box which pops up and
has a progress bar and the word "Saving"), and then pops up a message
box with "Access denied. Contact your administrator.". My
administrator has no clue, except to say that it's probably excel
having some sort of issue saving to the network. The part that REALLY
bothers me is that it's only about half of the time. I could
understand if it were EVERY time, but can't figure out half.

Any ideas? Known bug, to be fixed in SP1?

Any help you could give would be wonderful. Thanks,

Idle possibility ... maybe you don't have enough network drive quota ? ...
might need to be twice the file size free, depending on how it does the
save.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top