Referending Another Worksheet in the Same Workbook

  • Thread starter Thread starter chickalina
  • Start date Start date
C

chickalina

I have a workbook with contact names, numbers, and a combination of both. I
have a landscape version and a portrait version. I want to only update one
and the other automatically updates. I used the "=" sign. When I first
created the workbook, everything worked fine. I've since made some changes by
deleting and adding. Now some cells don't work. I've tried using the "="
sign again, changing the format to General and Number, but some cells refuse
to work.
Please help....
Thanks so much.
 
Those responding to questions provide answers on a voluntary basis and at
any particular point in time those who answer may or may not be on line. So,
please ask your questions once and be patient.

Your question is rather broad. Here are some suggestions for you to check.
If these don't work try asking your question again with more detail than
"now some cells don't work". You may know what this means but it is very
difficult for others to perceive the exact nature of your problem.

1) Rethink the need for a second workbook. If it is only a matter of
landscape or portrait, can you use macros to make relative adjustments in
the one workbook?

2) Have you tried copy/paste or a working link over a non-working link? NOTE
you need to make sure relative references will copy using this method. In
other words when you press '=' and enter the reference to your other
workbook it will enter something link '=[test.xls]Sheet1!$A$1' into your
cell. You need to remove the '$' symbols before copy/paste to other cells
to maintain relative referencing (i.e before you commence copying it should
look like the following

=[test.xls]Sheet1!A1

3) Try the following to ensure that your links automatically update.

http://www.ozgrid.com/VBA/update-links.htm
 
If you delete a row that is already referenced, than you're going to get
a #ref error most of the time. You may need to redo your formula.

If your formula is too complex to redo, than you may wish to consider a
VBA alternative to your complex formula (i.e. a user-defined function).

Regards,

That One Guy
 
Back
Top