I have a little (BIG) problem with Excel and my Unstable corperate network. When a server connection or network resource is lost and a user wishes to save their document that resides on that resource, the user will often receive the message "Document Not Saved". This obviously occurs because the path to save to has been lost, however... For some reason Excel/Windows is not smart enough to tell when the connection has returned and the document will continue to not save indefinitely.
My solution to the problem is creating a new temporary spreadsheet, copying and pasting the information to that sheet, then using the provided template copy and paste the data into a new template and rename the template to resemble the original file.
Now if that didnt confuse you then ur one of the few...
I have contemplated writing a macro which does all of this in a single click but I am not a fan of band-aid solutions.
Is there a way to Refresh Excel to its outside connections or force it to save once the connection has returned?
Excel wont even save to the desktop after such an event has occured. Please! Help!....
Thanks,
tW33k
My solution to the problem is creating a new temporary spreadsheet, copying and pasting the information to that sheet, then using the provided template copy and paste the data into a new template and rename the template to resemble the original file.
Now if that didnt confuse you then ur one of the few...
I have contemplated writing a macro which does all of this in a single click but I am not a fan of band-aid solutions.
Is there a way to Refresh Excel to its outside connections or force it to save once the connection has returned?
Excel wont even save to the desktop after such an event has occured. Please! Help!....
Thanks,
tW33k