Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Data refresh removes formulas
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
I hope I can explain this simply enough. I have created a table via 'Get and Transform Data'. Once loaded, I added 3 new columns that were not in the source table. Note: One of these new columns has a formula in it. I then did another 'Get and Transform Data' from the loaded table with the new columns and only created a connection. I then went back to the original query and merged the two together. All of this worked out perfectly well, no problems. The problem I'm running into, and maybe there's no fix; hope not, is when I 'Refresh' the table, I loose my formulas. If I enter data, instead of a formula into the columns, all is fine, the data is not removed. Is there a way I can keep my formulas from being removed?
Microsoft 365 and Office | Excel | For home | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.