Printable View
We have a share folder in our network. Everytime when we save the excel file...this screen comes up:
http://img.photobucket.com/albums/v3...screenshot.bmp
After we click on either 'Save a copy' or 'Overwrite changes...the file almost instantly disappears from the network drive, and the only way to get it back is to use the backup files or the backup tape. You guys have any suggestions?
Where are you saving the file? That prompt might be saving it locally. Did you google?
Our network drive is O: ... and yeah i googled already, but couldnt find anything. We work on documents and save it on the network drive.
What OS are you running??
What OS is the server running??
Did you search your local machine?
Did you search your O drive.?
Did you refresh?
What version of excel??
Do you have anti virus running??
More info please :D
Make sure you have the correct premissions to the O: drive
Hi jbomber,
Have u made ur excel file as "shared" ? if u have not made it as shared it will over write everytime u save it and anybody saves it in the network. Instead if u make it as "shared" it will incorporate all the changes from all the users and everybodys changes will be reflected.
Go to Tools > share workbook.
thre it will prompt u for the shareing permissions. just select with what all login ids u want to share the xcel file and it should work perfect.
hope this helps.
In
Does the same thing happen with Word documents or Access databases?
Does it happen with ALL Excel spreadsheets or just a particular one?
Have you always had this problem, or is it something recent?
Is your MS office up to date?
EDIT:
What happens if you select ,<save as> and give it a different name and save it to O:\
Cheers
Thanks for the responses guys...keep em coming...in the meantime i'll answer your questions.
What OS are you running?? Client Win XP
What OS is the server running?? Windows Server 2003
Did you search your local machine? Yes did not find it
Did you search your O drive.? Yes no luck
Did you refresh? No but we are losing files that need
to be restored from a prior day
What version of excel?? Office 2003
Do you have anti virus running?? Yes Symantec AntiVirus™ Corporate Edition
__________________________________________________________________________
Does the same thing happen with Word documents or Access databases?
Word documents also have this happen to it… Centralized into on Folder’s Child
components.. I.E…. O:/Folder1\Folder1\folder3 where contents in Folder 3 are
disappearing.. No other files are disappearing in any other Folder1 within O:
Does it happen with ALL Excel spreadsheets or just a particular one? 90%
Have you always had this problem, or is it something recent? 2 3 months
Is your MS office up to date? Yes
EDIT:
What happens if you select ,<save as> and give it a different name and save it to O:\
We have tried Save… Save AS… we will get the message box (the picture in the first post of this thread)
Try using 'save as' in the Excel file menu, then picking a different name and location to save your file.
Are you running exel from local machine or is your server 2003 running as an application server and you use exel as a client??
Here is a MS KB Article..
http://support.microsoft.com/default...b;en-us;271513
• You save an Excel file to a network drive where you have restricted permissions.
• You save an Excel file to a location that does not have sufficient drive space.
• The connection to the Excel file has been lost.
• There is a conflict with an antivirus software program.
• You save an Excel file that is shared.
• The 218-character path limitation has been exceeded when you save an Excel file.
• The Transition Formula Evaluation feature is turned on in Excel.
• The file was created from a template that contains embedded objects.
HTHs
MLF
Thanks guys for all the suggestions. I'll look over the above article and see how that goes.Quote:
Originally posted here by morganlefay
[B]Here is a MS KB Article..
http://support.microsoft.com/default...b;en-us;271513
Office 2003 is running locally.Quote:
Are you running exel from local machine or is your server 2003 running as an application server and you use exel as a client??