• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Content of names changed automatically to something wrong

cyrilz

New Member
Hello all,


I'm a bit afraid with this one.


In a shared workbook, I've defined a bunch of names, refering to columns in some sheets.

When I open the file, the names refers to the values I've entered.

When I click on a tab sheet, the references changes to something wrong.


Let me illustrated this :

CORR_CR_EXIG refers to

Code:
Corrections!H17:H52

and when I clicked, it refers to

Corrections!XFD10:XFD45

I've never seen this before, all my others sheets behave normally (even with external data links like this one).


The only difference is that the workbook is shared (I've never used it before).


Any idea ?
 

cyrilz

New Member
Thanks Hui,


I used to do so, but the formulas didn't update when I added a column and suppressed some lines as they were supposed to do.


So I switched to relatives ones, with the same result.


Have you ever encountered something like this ?


Here are the screenshots


Before Click

After Click
 

cyrilz

New Member
Ok, I've switched back to absolutes references, and now it all OK.


When I add or remove column/lines references follow.


Sorry for this and thanks for your help
 
Top