Keep getting Large Operation Message

%3CLINGO-SUB%20id%3D%22lingo-sub-2190657%22%20slang%3D%22en-US%22%3EKeep%20getting%20Large%20Operation%20Message%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2190657%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20Excel%20sheet%20for%20simple%20bookkeeping.%26nbsp%3B%20There%20are%20about%20285%20entries.%26nbsp%3B%20I%20have%20sorted%20it%20according%20to%20project%20name.%26nbsp%3B%20I%20want%20to%20add%20blank%20rows%20under%20each%20project%20grouping%2C%20put%20sub-totals%20for%20that%20particular%20project%2C%20and%20then%20at%20the%20very%20bottom%20calculated%20the%20grand%20totals%20for%20the%20different%20categories.%26nbsp%3B%20I%20did%20this%20yesterday%20for%20the%202019%20sheet.%26nbsp%3B%20Today%2C%20while%20doing%20the%202020%20sheet%2C%20I%20sorted%20by%20project%2C%20inserted%20some%20rows%20at%20the%20bottom%20of%20the%20first%20project%2C%20and%20typed%20in%20Sum%20formulas%20for%20each%20column.%26nbsp%3B%20Now%2C%20I%20scroll%20down%20to%20the%20bottom%20of%20the%20second%20project%20section%2C%20and%20attempt%20to%20insert%20some%20blank%20rows.%26nbsp%3B%20I%20keep%20getting%20the%20warning%20that%20this%20is%20a%20large%20operation%20affecting%20many%20cells%2C%20and%20do%20I%20want%20to%20proceed.%26nbsp%3B%20I%20closed%20it%2C%20restarted%20my%20computer%2C%20and%20reopened%20Excel.%26nbsp%3B%20When%20it%20was%20opening%2C%20my%20computer%20said%20this%20item%20is%205.98%20MB%20which%20is%20huge%20for%20a%20small%20sheet%20like%20this.%26nbsp%3B%20I%20suspect%20there%20is%20hidden%20code%20someplace%2C%20but%20can't%20find%20it.%26nbsp%3B%20What%20do%20you%20recommend%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2190657%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I have an Excel sheet for simple bookkeeping.  There are about 285 entries.  I have sorted it according to project name.  I want to add blank rows under each project grouping, put sub-totals for that particular project, and then at the very bottom calculated the grand totals for the different categories.  I did this yesterday for the 2019 sheet.  Today, while doing the 2020 sheet, I sorted by project, inserted some rows at the bottom of the first project, and typed in Sum formulas for each column.  Now, I scroll down to the bottom of the second project section, and attempt to insert some blank rows.  I keep getting the warning that this is a large operation affecting many cells, and do I want to proceed.  I closed it, restarted my computer, and reopened Excel.  When it was opening, my computer said this item is 5.98 MB which is huge for a small sheet like this.  I suspect there is hidden code someplace, but can't find it.  What do you recommend?

1 Reply
It could be that excel thinks the used range is much larger than it actually is. Do you have unnecessary formatting (some people select entire rows/columns when applying cell formatting)?

See here for more information:
https://support.microsoft.com/en-us/office/locate-and-reset-the-last-cell-on-a-worksheet-c9e468a8-0f...