Copy worksheet not allowing to cross reference

[RobSA]

Hi Folks,


I have copied a work sheet (DB01) and given it another name (DB02.


I have data in a worksheet called INPUTS.


Whe I want to utilise the data from a cell in the INPUTS so that the data appears in the DB02 worksheet, I get the actual location rather than the value I request i.e.+INPUTS!K16


I would appreciate some advice as to why this happens?


Regards

Rob

 

[Luke M]

Make sure that the cell containing the formula is not formatted to text. If it is, change the format, then re-enter the formula.