ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Input missing (https://www.excelbanter.com/excel-discussion-misc-queries/70100-input-missing.html)

Hotline SME

Input missing
 
Weekly my team makes updates to an excel spreadsheet that is located on a
shared drive. Nine people make updates all week for me to do reports on
Friday. I retrieve the updates on Friday mornings. However, everyone's
updates to the spreadsheet are saved except one person.

Conundrum: The one person's input is visible on the spreadsheet Tuesday
through Thursday, but not on the spreadsheet on Friday morning.

exceluserforeman

Input missing
 
There is an AutoUpdateChanges in options, Saves every x seconds, set by the
user. I suggest you use it.




"Hotline SME" wrote:

Weekly my team makes updates to an excel spreadsheet that is located on a
shared drive. Nine people make updates all week for me to do reports on
Friday. I retrieve the updates on Friday mornings. However, everyone's
updates to the spreadsheet are saved except one person.

Conundrum: The one person's input is visible on the spreadsheet Tuesday
through Thursday, but not on the spreadsheet on Friday morning.



All times are GMT +1. The time now is 08:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com