Home

Updating values between 2 different spreadsheets by 2 different users

%3CLINGO-SUB%20id%3D%22lingo-sub-810983%22%20slang%3D%22en-US%22%3EUpdating%20values%20between%202%20different%20spreadsheets%20by%202%20different%20users%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-810983%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHi%20all%2C%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EI've%20created%202%20spreadsheets%20to%20use%20in%20a%20mock%20scenario%20for%20testing%20my%20department's%20flood%20response%20procedures.%20On%20the%201st%20spreadsheet%20(called%20Location)%2C%20I've%20written%20a%20macro%20to%20constantly%20increase%20the%20value%20of%20the%20river%20levels%20every%20minute.%20The%202nd%20spreadsheet%20(called%20Overview)%20then%20has%20links%20to%20cell%20values%20and%20has%20an%20automatically%20updating%20chart%20based%20on%20values%20from%20the%20Location%20spreadsheet.%20When%20I%20have%20both%20spreadsheets%20open%20on%20the%20same%20laptop%2C%20the%20Overview%20spreadsheet%20automatically%20updates%20the%20values%20every%20time%20the%20values%20increase%20on%20the%20Location%20spreadsheet.%20But%20when%20I%20have%20the%20spreadsheets%20open%20on%20different%20computers%2C%20the%20values%20do%20not%20automatically%20update.%20For%20the%20scenario%2C%20I%20will%20need%20to%20have%20the%20spreadsheets%20open%20on%20different%20computers%20as%20staff%20will%20be%20based%20in%20different%20offices.%20Both%20spreadsheets%20are%20on%20our%20shared%20network%20drive.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EI%20have%20tried%20sharing%20the%20Location%20spreadsheet%2C%20and%20having%20this%20open%20on%20both%20computers.%20This%20does%20work%2C%20but%20it%20can%20only%20update%20every%205%20minutes%2C%20which%20is%20not%20often%20enough%2C%20and%20it%20also%20messes%20up%20the%20macros%20on%20the%20spreadsheet.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EDoes%20anyone%20have%20any%20suggestions%3F%20I'm%20using%20Excel%202013.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EThanks%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-810983%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Jonathan_Allchin
Occasional Visitor

Hi all,

I've created 2 spreadsheets to use in a mock scenario for testing my department's flood response procedures. On the 1st spreadsheet (called Location), I've written a macro to constantly increase the value of the river levels every minute. The 2nd spreadsheet (called Overview) then has links to cell values and has an automatically updating chart based on values from the Location spreadsheet. When I have both spreadsheets open on the same laptop, the Overview spreadsheet automatically updates the values every time the values increase on the Location spreadsheet. But when I have the spreadsheets open on different computers, the values do not automatically update. For the scenario, I will need to have the spreadsheets open on different computers as staff will be based in different offices. Both spreadsheets are on our shared network drive.

I have tried sharing the Location spreadsheet, and having this open on both computers. This does work, but it can only update every 5 minutes, which is not often enough, and it also messes up the macros on the spreadsheet.

Does anyone have any suggestions? I'm using Excel 2013.

Thanks

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies