Forum Discussion
Formula not evaluated with import Data from Web Office 2019 and newer
Hi,
Thanks for answering, but i want to use Table option, with old wizard, it create a range not a table.
So having a table give me access to all options a table have (look, autosize, etc ...)
Regards
Super UserI haven't played with the legacy wizard to advise you with regard to that. But you can always add the formula columns as custom columns within Power Query. Or you could re-write your formulas to use table references to the table that PQ generates. I believe the first option will be more stable.
Unfortunatly, making some formula in PowerQuery goes against my goal;
Delivering a web table with everythings included (even formulas) allow me to update workbooks contents without even updating the file itself.
I really don't get why Excel does not try to evaluate the cells like legacy one do.I feel that a column type "Excel Formula" is missing int the columns types list into Power Query.
- KNP
I can imagine this is very frustrating.
Unfortunately I don't have a good solution for you if you don't want to convert this to a Power Query only solution.
You could see if the answers in this post are of any use to you...
https://stackoverflow.com/questions/31293828/excel-doesnt-update-value-unless-i-hit-enter/31294048
Hi,
Well there are a lot of hints in this link that i wan try... i'll try all of them and see what happen.
I'll keep ou posted.
Regards
- ronrsnfld
Then use my second option
Hi
Actually, i firstly missread you message, i'll try this thing to re write formulas using table references and see.
I had this idea, but was too lazy t try and eventually forgot it by getting so much annoyed 😛
Thx
Regards
