Of course, Excel will have to recalculate all the formulas in your spreadsheet to make adjustments for the newly inserted column. For instance, say your spreadsheet contains a million formulas on a sheet, then you insert another column. Problems with Calculations: The error might be related to a recalculation of formulas when you insert rows and columns, copy and paste or perform calculations.The Excel versions (Excel 2007, 2010, 2013, and so on) 32-bit is limited because of the setting to 2GB (or 32,760 source cells in cases where you use a smart fill option) so trying to work with large sections of the worksheet will only trigger this error. Thus, you are most likely to receive these error messages when trying to copy or fill formulas into a large area on your worksheet. Trying to Copy Formulas over A Large Area: If your Excel file is large or contains many features, your memory resources may just be running low.
