Forum Discussion

Copper Contributor

Jul 25, 2018

Problem/Strange behavior by renaming sheet

I recently discovererd a behavior in Excel 2016 where I'm not sure if it is "works as designed" or a faulty behavior: Two open workbooks Rename a sheet in the first book (Original name "Sheet1") ...

excel

Constance_

Copper Contributor

Feb 10, 2019

Hello to all members

Since today I have problem to change the name of the table sheets. Each time I select Tableau1 (have a french version) and type a name it returns immediately to Tab1. Impossible even to type some precision after Tab1. Very uncomfortable as I use always my own name of sheets in formula,, dynamic table etc..

Is there something to check in the "preferences" or elsewhere?

My version :Excel in Office for Mac 2016 (student and family) Version 16.21.1 (190123)

I am afraid the software maybe corrupted (it has a year) bought in Microsoft online store.

Any tip or idea would be strongly appreciate.

Thanks

Constance

Constance_

Copper Contributor

Feb 11, 2019

Solution was easy. Sorry to have asked before trying it.

I had copy (copy + paste) a table coming from an older version of excel in my new sheet with other version of Excel. Erratic behaviour must have been related to the old format.

I had to redo the all table in the new sheet and everything turn back to normal.

Anyway it is annoying not to be able to copy sheets from an old version of Excel.

Constance