Forum Discussion

Bernhard Rogge's avatar
Bernhard Rogge
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
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jul 25, 2018

Hi Bernhard,

 

My guess that's since by default Excel 2016 opens each new workbook in the same instance. If you start new instance for the second workbook it works - rename without Enter and clicking in same workbook, go on second one, return back on first and we sheet keeps new name.

  • Constance_'s avatar
    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_'s avatar
      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

  • Bernhard Rogge's avatar
    Bernhard Rogge
    Copper Contributor
    Jul 25, 2018

    Hello Sergej,

     

    thanks a lot for the quick reply.

     

    We fought so hard for this feature over the past. And that is the reason why I raised the question "works as designed" or faulty behavior? Problably nobody paid attention when they changed the document Interface. And of course I admit the described way is not a way everyone works every day. xD

Resources