pantsmonkey
Board Regular
- Joined
- Jul 2, 2002
- Messages
- 109
Hello Boffins.
My workplace uses a shared XL spreadsheet which is basically a huge calender of out outbound freight history. Dates along the top and stock numbers down the side.
Eg We send out stock 111 on the 21/03/09 and it comes back on the 28/03/09 those cells are highlight green when it goes out and the whole thing become yellow the day its returned.
It kinda gives us a visual look at our stock and is useful.
The pain in the butt problem is with 3 people working on this shared document occasionally one of the 3 with the shared document open (its open all day every day) will forget to save regularly or after an update and to the other users it's effectivly invisible until the save button is clicked.
I have gone into the save and autorecover options in XL and the option to autosave is grayed out?
Is this a limitation of a shared workbook or is there anyway I can force the thing to save on every machine it's open on every 60 - 90 seconds?
Cheers Boofins
Happy Friday!
My workplace uses a shared XL spreadsheet which is basically a huge calender of out outbound freight history. Dates along the top and stock numbers down the side.
Eg We send out stock 111 on the 21/03/09 and it comes back on the 28/03/09 those cells are highlight green when it goes out and the whole thing become yellow the day its returned.
It kinda gives us a visual look at our stock and is useful.
The pain in the butt problem is with 3 people working on this shared document occasionally one of the 3 with the shared document open (its open all day every day) will forget to save regularly or after an update and to the other users it's effectivly invisible until the save button is clicked.
I have gone into the save and autorecover options in XL and the option to autosave is grayed out?
Is this a limitation of a shared workbook or is there anyway I can force the thing to save on every machine it's open on every 60 - 90 seconds?
Cheers Boofins
Happy Friday!
