I am using Microsoft Excel for Mac Version 16.26 as part of office 365 subscription.
I maintain invoices of my business into one spreadsheet with many different sheets as they reflect vendors. I do calculations on each item about my expenses and selling price. Each sheet has many invoices and corresponding calculations.
Lately I am seeing whenever I add a row or touch a cell or scrolling the sheet it is taking lot of time and showing as "Application not responding" Especially some of the sheets even slower. I did my research and I couldn't find any solution to resolve this. Can anyone from the community help me out how to fix this issue ? Appreciate help on this.