Multiple sheets

Hello Bianca,

Thank you for your question. It sounds like you're dealing with a corrupted Excel file or an issue related to file permissions or shared access. Here’s a step-by-step approach to troubleshoot and resolve the problem:

1. Check for File Permissions or Accessibility
- File in Use: Make sure the file is not open on another device or by another user. This can happen if the workbook is on a shared network drive.
- File Location: Ensure the location where you are saving the file is accessible (e.g., a network drive, local storage, or OneDrive).
- Read-Only Mode: Verify if the workbook is in “Read-Only” mode. If so, try to save a copy under a new name.

2. Check for Corruption in Linked Workbooks
- Since your workbook receives data from other workbooks, there could be corruption in one of the source files. Open each linked workbook individually to ensure none are corrupted.
- If the linked workbooks open successfully, check if their formulas or links are causing the issue by breaking the links temporarily:
- Go to Data → Edit Links → Select the link → Break Link.

3. Open and Repair the Workbook
Excel has a built-in repair tool. Try these steps:
- Open Excel, and go to File → Open.
- Browse and select the corrupted workbook.
- Before opening, click the arrow next to the Open button and choose Open and Repair.
- Choose Repair to recover as much data as possible.
- If repair fails, choose Extract Data to retrieve cell data and formulas.

4. Save the Workbook with a Different Name or Location
- Sometimes, simply saving the workbook to a different location (e.g., your local hard drive instead of a network drive) or under a new name can resolve the issue.
- Go to File → Save As and save it in a new location or with a different name.

5. Clear Unnecessary Workbook Features
Features such as macros, excessive formatting, and unused worksheets might cause the workbook to become unstable. Try the following:
- Remove Unused Macros: Go to Developer → Macros, and delete any macros that are not needed.
- Remove Unused Sheets: Delete any unnecessary sheets from the workbook.
- Minimize File Size: Large files can become problematic. Try reducing the file size by clearing unused ranges:
- Select all unused rows and columns, right-click, and select Delete.

6. Check for Excel Updates or Reinstall
- Ensure you have the latest version of Excel by going to File → Account → Update Options.
- If Excel is up to date but the issue persists, try reinstalling Microsoft Office to eliminate any installation issues.

7. Save as a Different File Format
If none of the above steps work, try saving the workbook in a different format:
- Save as a .xlsx if the workbook is currently in .xls format or vice versa.
- Alternatively, try saving it as a .csv to see if it saves correctly (you will lose formatting and formulas, but the data will be preserved).

8. Check for Add-ins and External Software Conflicts
Sometimes Excel add-ins can cause conflicts or corrupt workbooks. Disable any active add-ins and retry:
- Go to File → Options → Add-Ins → Manage COM Add-ins → Uncheck all add-ins and click OK.
- Try saving the file again without the add-ins enabled.

I hope that one or more of the above checks will help the data update properly. If not, please ask again for assistance.

Kind regards
Marius Barnard
STL