2010 excel file not working in Office

Administrative Note:

Welcome to the forum.

Is your forum profile showing the Excel PRODUCT that you need this to work for?

Members will tailor the solutions they offer to the Office PRODUCT (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your product is for Mac, please also state this.

The three most recent Excel products are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the version number in your profile (e.g. MS365 Version 2306). This is in the About Excel section further down the Account page.

Thanks.

If this old workbook contains macros, then it will need to be saved with the new .xlsm suffix. Is this something that you have already tried?

What doesn't work? I have opened it and saved it as .xlsx format. It seems to use shapes (lines specifically) around cells rather than using borders. I'm not sure why that is but they get in the way of accessing the cells themselves. You can select a cell next to the cell you want and arrow left (or right) to get at the cell and edit it if you wish.

You can select each of the shapes/lines and delete them. And you could replace them with borders. Tedious job but doable.

Looks like the file hasn't been used for 20 years.

I asked you to update your forum profile - please do so NOW. Then read post #5.

Please read and act upon post #7.

And there is no picture attached.

See my screenshot.

Thank you.

See post #5.

OK. I can see the problem. When I open the workbook in Excel 2010, the behaviour is slightly different. If you click around the edge of the cell, you select the line (you'll see the name of the line in the Name Box (to the left of the Formula Box)). If you click bang in the middle of the cell, it selects the cell. You can see the difference in the mouse pointer. It changes to a cross-hair when the line is going to be selected and a big plus sign when the cell itself will be selected.

With 365, and obviously 2019, it's not that easy. If you zoom to 110%, you can select the cells in the same way as on 2010. Not ideal but it seems to work for me.

The only other way would be to delete the lines and replace them with borders. There are a LOT of lines.

The only other way would be to delete the lines and replace them with borders. There are a LOT of lines.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

You're welcome. Thanks for the rep.