Aug 20 2020 06:49 PM - edited Aug 21 2020 09:39 PM
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 properties but nothing seems to be working.
Thanks
Aug 21 2020 06:00 AM
Aug 21 2020 11:52 AM
@Jan Karel Pieterse 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.
Aug 24 2020 05:09 AM