|We have some spreadsheets where tabs with detail feed to another tab that has the summary in the same workbook. For certain staff only, it does not update the tab once the new data is input. For other users with the same version of Excel, it updates as it should. |
The tab that needs to be updated is a summary tab that is protected so we are unable to just to manually have it point to the updated totals. We've attempted saving as new files completely and that didn't work. We've tried selecting the whole tab and making a copy and that didn't work either.
Any ideas on how to get this to work for all users would be appreciated.