I have an excel table (say Table1) which is loaded using a power query.

Table1 has data which looks like the following:

Now I ran a query on table1 to add a blank row for each product, to calculate “Cost of Goods Sold”. And I set the default values to be 0 for 2027 and 2028 columns for “Cost of Goods Sold”.

Now I want the user to be able to enter the value for “Cost of Goods Sold” in the excel table but every time I refresh the excel, the values that I enter manually get turned back to 0 again.

How do I get the values that I enter to stay?

​I have an excel table (say Table1) which is loaded using a power query. Table1 has data which looks like the following: Now I ran a query on table1 to add a blank row for each product, to calculate “Cost of Goods Sold”. And I set the default values to be 0 for 2027 and 2028 columns for “Cost of Goods Sold”. Now I want the user to be able to enter the value for “Cost of Goods Sold” in the excel table but every time I refresh the excel, the values that I enter manually get turned back to 0 again. How do I get the values that I enter to stay?  Read More

​