I have a document on my company's server. When I open the file from my desktop and make changes, I'd like to hit the "Save" button and have the changes saved in both locations. Putting a shortcut on my desktop doesn't help because when I leave the office my laptop will not be able to open the file.
I know I can manually save the document in both locations, but I'd really like to have it saved automatically in both spots. Does anyone know if and how this is possible?
2006-10-25 05:07:53 · 5 answers · asked by Anonymous in Computers & Internet ➔ Software
You can record a macro:
Got to Tools, Look for Macro,
when you highlight Macro, a drop down menu will appear, select record New Macro.
The "record macro" window appears, change the macro name to something like "SaveInDesktopAndServer" and hit ok.
A small window with the "Stop" square appears, this means that the macro is being recorded, which means that all your actions in excel are being recorded.
Save the file in your server and then in your desktop how you would normally do. Once you are done press the stop button.
Now every time you run the macro it should save the file in the two locations. To run the macro just hit Alt + F8, a window with all the macros should appear, select the one you recorded and hit Run.
2006-10-25 05:28:16 · answer #1 · answered by fe_garci 1 · 0⤊ 0⤋
After the first save on the server, do a save as on the desktop - overwriting your file.
Also you can add a shutdown script that will sync the files.
2006-10-25 12:10:40 · answer #2 · answered by orlandobillybob 6 · 0⤊ 0⤋
Check with your IT department and ask if you have a roaming profile. If you do then when you log off all your documents on your hard drive will be synchronized with the server.
2006-10-25 13:03:09 · answer #3 · answered by Mike 3 · 0⤊ 0⤋
Just hit save twice.
The other way is too much work.
2006-10-25 12:10:42 · answer #4 · answered by bequalming 5 · 0⤊ 0⤋
thats not possible as both are different
2006-10-25 12:20:32 · answer #5 · answered by karthick s 2 · 0⤊ 0⤋