Refenced cells are not displaying correctly from another sheet

  • Thread starter James C. Hooper
  • Start date
J

James C. Hooper

I have a big spread sheet, Excel 97, that has many
sheets. The main sheet is called Information. From this
I have a lot of smaller sheets that I pull information
from from the main sheet Information. To do this I go to
one of these other sheets and click on the = sign on the
formula bar. Then I click on the Information sheet and
then go to the cell I want and hit enter and now the data
is displaying fine in the new sheet. I do this a lot and
it works fine. Now I'm trying to pull some data from the
sheet Information in a smaller sheet called Bin. Some of
the data is displaying fine in the sheet Bin and others
are displaying "=Information!I51" (minus the double
quotes) instead of the data inside of Cell I51. I sure I
don't have typos.

Another funny thing is if I click on the = sign again in
formular bar of the sheet Bin a box will pop up that say
Formula Results = 593, which is what I want to display and
not "=Information!I51" (minus the double quotes). This is
happening in several cells and some are working fine.
Changing the format of the source and the target cells
hasn't fixed it either.

If possible please email me at: (e-mail address removed)
 
J

James Hooper

Niek, that fixed, thanks. Yesterday when I was working
with it I tried changing it to General while the data was
already there and that didn't help. Changing it to
General before I put the data in there fixed it - as you
said.

Funny thing is several, but not many cells, formatted as
text work.
 
A

Anon

Changing the format to/from text AFTER the 'formula' is entered only affects
the way the formula result is displayed. However, changing it BEFORE the
'formula' is entered will affect whether what you enter will be treated as
text or a genuine formula.

Of course, 'before' and 'after' here are relative to the LAST time that an
entry was made. If you enter a 'formula', then change the format, and then
edit the cell, you are entering at this point (with the new format in
place).
 

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

Creating a Chart on form from selected data in query. 0
copy specific cells from sheets if the information is correct 3
Copy entire row from another sheet onto first sheet if a unique text matches 1
how to copy and paste value from one sheet to another 4
Copy Data from One sheet to Different Sheets 1
Pulling background color from master to other sheet 2
selecting workbook/sheet 3
Excel formula help for calculating freight. 2

Top