calculations quit working

[Guest]

Well heck ... I typed a long answer and it seems to have disappeared ...
maybe I clicked the wrong button ... it's been a long day

Anyway ... There are thirteen names in the Name Define area ... I was in a
cell on the worksheet and when I clicked on the Name Define place, I selected
the first name and changed the reference from row 1000 to row 2000 ... then I
clicked on another name and did the same thing, until I did all the names ...
then I clicked on another cell and checked the Name Define place and they all
said 1000 again ... so I thought I had to change each individual cell

Turns out the 2000 isn't sticking and for the life of me I cannot figure out
why ... I even went to one of the named columns and selected it all the way
down to 2000, then clicked on the name range place and selected it from the
drop down list ... but it went right back to 1000

I'm not sure if I'm editing this correctly ...???

 

[Dave Peterson]

After you change the "refers to" box, make sure you hit the Add button.

 

[Ron Rosenfeld]

Hmmm. Did the LAST name you changed "take"? The one you changed just before
you clicked <OK>?

If it did, try clicking the <ADD> button after you make each change. And then
it should "take"

------------------------

Well heck ... I typed a long answer and it seems to have disappeared ...
maybe I clicked the wrong button ... it's been a long day

Anyway ... There are thirteen names in the Name Define area ... I was in a
cell on the worksheet and when I clicked on the Name Define place, I selected
the first name and changed the reference from row 1000 to row 2000 ... then I
clicked on another name and did the same thing, until I did all the names ...
then I clicked on another cell and checked the Name Define place and they all
said 1000 again ... so I thought I had to change each individual cell

Turns out the 2000 isn't sticking and for the life of me I cannot figure out
why ... I even went to one of the named columns and selected it all the way
down to 2000, then clicked on the name range place and selected it from the
drop down list ... but it went right back to 1000

I'm not sure if I'm editing this correctly ...???

--ron

 

[Guest]

That worked ...!!!

Thank you all for your help today ... I've learned a lot

@}~~~~~~~ CJ

 

[Guest]

Well that little "=" trick helped ME out. I lose my calculations/links when
I move a sheet from one position to another within the workbook. I still
don't know why that happens or how to prevent it but at least I can repair it
now. Thanks!!