Changed referenced cell between sheets

  • Thread starter Thread starter nikos1960
  • Start date Start date
N

nikos1960

I am running multiple excel sheets , located in a file server, with long
file and folder names and I have many links between cells of different
sheets. I suddenly realized that a cell referenced in cell c24 of
another sheet now is pointing cell c23 of the same sheet.

Can somebody help
 
Niko,

what exactly do you mean? Tell us the formula in C24 and what do you
mean by the referenced cell pointing to another cell.
From the little I understood from your words, this is a behavior that
Click to expand...
can come about if a cell is deleted. E.g. If I have a formula =C18 and
then one of the cells above is deleted, C18 moves up and now becomes
C17. The formula will also change and will show =C17. Is this your
case? Then I am not sure you can do much about it. Maybe though the
layout is such that something can be fixed. At any rate, you have to be
more specific.

HTH
Kostis Vezerides
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF function and cell /sheet reference 3
Excel keeps copying formulas into other cells!! 2
Copy Sheet #'s, but leave cell reference 3
Referencing the same cell on multiple sheets 1
Populate Data from Summary Sheet 5
How do I link cells between to sheets in MS Excel? 3
Sheet Names and Auto-calculation 2
How to use cell fron different sheet in IF statement 5

Back
Top