Forum Discussion
Non-active references to text formated cells
- 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.
That report is generated by regular worker who should not play with excel file to circumvent the software issues.
I have described that replace = with = is one of the ways to activate the links. Another one is to tick on/off 'Options>Advanced>Lotus Compatibility settings for //>transition formula evaluation.
However , one must do that operation for every worksheet with those links, and actual setting of that option does not matter. If it is 'on' it must be switched off, it it is off it must be switched on.
Maybe there are some other settings/or some combinations of those settings which I am not aware off. To be honest I do not understand what this 'lotus compatibility option' is , I came accross it working on some other issue which was resolved in the meantime,
