How to add rows to a table without having the formulas auto populate?

Copper Contributor

When I add rows to a table, the formulas seem to be embedded in the table and they are auto populating. My data set is large so it's causing it to crash. What's weird is that not all formulas are auto populating, only certain columns. I don't want any of the formulas to populate. I want to just copy and paste them after I add my data to the table. Hope this makes sense. I truly appreciate any help that is out there because it would save me a ton of time. Thanks in advanced.

1 Reply

@Francs2345 

You may uncheck this setting in File->Options

image.png