Forum Discussion
Solved
Non-active references to text formated cells
Hello, I have created aplication which returns data into empty worksheet called in Excel, in the example below called Raport3. That data is then referenced in other worksheets through =IF(Raport3!B...
- Is calculation set to manual by any chance? Formula tab, Calculation options drop-down.
Hello,
The calculation of formulas is set to automatic. The data I am trying to reference is a report from extrnal app. it is generated as csv and pasted into excel as string values. I need to reference that data into main part of excel document. The cells are formatted as 'general' both in the source worksheet as in the worksheet with formulas.
Raport1,2, 3 are the worksheets with source data. Other worsheets take the data from there. E.g. see Ingredients Hazard Analysis. It is enough to click in the formula bar to activate the links. Otherwise those are dead.
You could do a search and replace, looking for the = sign and replacing with the = sign.