Forum Discussion
Losing formulas after refreshing workbook
Hello, I have a workbook that is connected to an external database (sql server). When I type in formulas (nested ifs), after refresh, I loose everything. I have tried changing the options under prop...
JKPieterse Thanks for your reply.
I tried that too by creating a new column and adding the formulas there, it worked, but after auto refresh it disappears as well.
Did you make sure all cells of the column contain the same formula (select all cells in column, edit first formula and press control+Enter to enter in all cells of the column)?