Excel file with Macros that opened recently, now when prompted to and enabled macros, data and worksheets do not appear

Question

I have an excel file that prompts me to enable macros to bring up worksheets and data and be able to work in the file. Every time (on my mac) I would get the prompt to enable macros I would allow and the data would appear, up until recently. Now when I enable macros through the prompt that appears (attached) I get no data and the worksheets that used to appear do not show up either (they have the data I was editing and working on). Instead this is all I see (also attached). Any thoughts on what could be causing this to now not pull up any of the worksheets I have been working on?

Answer 1

I suspect the workbook has corruption within it. Let's see if we can fix it.

Open the workbook.

Use File > Save As and choose a new file format, such as .xls (the old format for Excel) and then save the workbook.

Quit Excel (Command-Q)

Now open the saved .xls file and reverse the procedure using File > Save As and choosing .xlsm file format.

Quit Excel (Command-Q)

Now try opening the workbook

Is the workbook fixed?

Answer 2

Hi Jim,

When I do that I am able to open the new saved as .xlsm version but it does not prompt me to enable macros when opening, but does look like the layout above when opened with the promt to enable macros is cell A1

Answer 3

Do the macros work?

Answer 4

No they did not.

Answer 5

Does the workbook contain any private, personal or confidential information? If not, please upload it to a sharing site and then share the link here so that others can have a look at this workbook.

Thanks.