We've a number of Excel Workbooks, with massive amounts of data. Getting some fields to auto-update when edited in another is pretty easy
(IE: "Test GRT II Field P31"='[RDC Staff On-Boarding BLISTER Tracker 03.04.20.xlsx]Master File'!$B$2").
But is there a way to get a workbook to open in a way that simulates how it would open through, say, Google files, so that more than one person can have it open and be able to successfully have their edits saved ("Auto Saving" whenever a change is made, for instance)?
Due to the sensitive nature of some of the information (PII: Personally Identifiable Information), we'd *NEVER* get approval to be able to actually place it on a Google Drive (which, of course, would make things infinitely easier), so I'm now trying to figure out how to make this a possibility.
Ideas??
(IE: "Test GRT II Field P31"='[RDC Staff On-Boarding BLISTER Tracker 03.04.20.xlsx]Master File'!$B$2").
But is there a way to get a workbook to open in a way that simulates how it would open through, say, Google files, so that more than one person can have it open and be able to successfully have their edits saved ("Auto Saving" whenever a change is made, for instance)?
Due to the sensitive nature of some of the information (PII: Personally Identifiable Information), we'd *NEVER* get approval to be able to actually place it on a Google Drive (which, of course, would make things infinitely easier), so I'm now trying to figure out how to make this a possibility.
Ideas??