question

Hi @JohnSmith-5704,
What version of Office are you using?
Did you mean the feature in Excel 2010 as shown in the following picture:

This feature is removed after Office 2010, if my understanding is incorrect you can try to provide a screenshot or be a bit more precise to explain your problem so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Hello:

Thanks for your prompt reply. After rooting around on my system, I've come to the following conclusion (possibly incorrect).

My computer is running Windows 10 Pro version 21H2. The Microsoft Office Excel is 2007 version 12.0.6612.1000.

However, the Excel files that had their Sheet/data/equations/links deleted were Excel 97-2003. I had created
these files on old computers running Windows 97 & Windows 7. Rather than recreating those Excel Spreadsheets and data all over again on newer computers I simply copied them across from backup disks.

I took a look at the Excel spreadsheet currently installed on my Windows 10 system. It does have the Sheet feature still available.

So, I suspect that some recent Cumulative/Quality update for Windows 10 version 21H2 possible cancelled the Excel Sheet feature for Excel 97-2003 versions.

So, it appears that I will have to open new Excel 2007 Spreadsheets with the Sheet feature and try to add back all the lost data/equations/links as best I can.

Thanks.

John Smith.