Excellink error

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:28 PM GMT

Question

QUESTION: In one worksheet i am pointing a cell to read the data in another worksheet in the same file. example ='Contract Review'!H4 However, in the above example the cell that is supposed to display the data retrieved from 'Contract Review'!H4 will only display the text ='Contract Review'!H4 What can be wrong.? I have other cells with a similar link format and some are OK and will display the data but others are not OK and have the same problem. Any idea's please...

ANSWER: The cell with the reference is formatted as text. Reformat it as general (shortcut: ctrl/shift/~) then re-enter it. OR the entire sheet is set to display formulas not values. Tools/Options/View tab/Window Options/Formulas - deselect that.

---------- FOLLOW-UP ----------

QUESTION:

Answer

send me the workbook - send to bobumlas@Yahoo.com, use subject of "AllExpertsQ" and redescribe the issue.

Advertisement

©2024 eLuminary LLC. All rights reserved.