I'm having a problem with a workbook that keeps getting corrupted. Even if I rebuild the file by hand in a new workbook, the problem persists which makes me think it's something wrong with my methodology. I'm running Excel 2013 32bit on Windows 7 64bit.
I have a suite of workbooks for tracking aspects of a budget. There are a series of workbooks for each component of the budget. Each sheet in each workbook contains a data table. There workbooks for different series of projects within a fiscal year that use the INDIRECT() function to collect data from those tables and lays out a budget for each of the projects in the series, not using tables.
Last there's a workbook that provides an overview, referencing named ranges in the series workbooks and collecting that data into tables that provide an overview of the whole fiscal year. It's this last workbook that keeps getting corrupted. I'll save the workbook and then try to open it again and get the following error:
Jim
I have a suite of workbooks for tracking aspects of a budget. There are a series of workbooks for each component of the budget. Each sheet in each workbook contains a data table. There workbooks for different series of projects within a fiscal year that use the INDIRECT() function to collect data from those tables and lays out a budget for each of the projects in the series, not using tables.
Last there's a workbook that provides an overview, referencing named ranges in the series workbooks and collecting that data into tables that provide an overview of the whole fiscal year. It's this last workbook that keeps getting corrupted. I'll save the workbook and then try to open it again and get the following error:
Excel found unreadable content in '2016Budget.Overview.xlsx'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes.
When you click yes Excel displays information on what was repaired:
Repaired Records: External formula reference from /xl/externalLinks/externalLink5.xml part (Cached values from external formula reference)
No matter how many times you repair and resave the file the problem recurs. As I mentioned, even remaking the file by hand doesn't fix the problem. What am I doing wrong? I managed to get rid of the problem by converting the tables to ranges and referencing cells $A$1 format but now I want to expand the Overview workbook to show additional information. I can do it without tables, but named ranges would be far and away the best tool for the job. Even trying to reference named ranges without putting the links in tables is causing the error. Any help in further diagnosing the problem would be greatly appreciated.
Jim
