Problem saving excel file

B

bsimo49

I have an Excel file which I can't save to the server nor local har
drive. When I open it and make a change and click on *-save as or sav
-*a dialog box appears and says*- file not saved-*. Even if I don'
make a change and just click on save it says the same thing. No specia
security settings are attached to the file. Anyway if someone can hel
that would be great, Thanks
 
D

Dave Peterson

The developer may have put a macro that runs each time you try to save the
file. That macro could be stopping the save.

If you close the file and reopen it with macros disabled, can you save it then?
 
B

bsimo49

Thanks but Tried disabling macro already but it still does not let m
save. Also have tried saving on a different PC and still having th
problem
 
D

Dave Peterson

You can't save it to your local harddrive, either?

I was thinking that the folder that contains the file may be readonly for you
(and the other user).

I don't have another guess.
 
M

m96

Dave said:
The developer may have put a macro that runs each time you try to save the
file. That macro could be stopping the save.
Click to expand...

good idea. since i'm using the same thing. if this is the case then you
could easily modfiy it:

press alt+f11 to open the vba editor then double-click "thisworkbook"
from the project window. if there is a macro "workbook_beforesave" then
delete it. now you should be able to save it.

hope it helps.
cheers.

If you close the file and reopen it with macros disabled, can you save it then?
Click to expand...
 
Top