Sample Header Ad - 728x90

Excel: Alert Limit Exceeded

0 votes
1 answer
77 views
I have a spreadsheet with a small number of cells - 4 tabs. - The biggest circa 860 rows x 30 columns = 25800 cells - The size of the spreadsheet on disk is 225KB. (222,467 bytes) - The cell count in the other 3 sheets are negligible - I think I am under the limits described here ! Hardware: - (MBP 2016) Quad Core Intel i7 - 16GB Memory - Activity Monitor says 7.29GB memory used at the time it happens. OS: - OS Monterey 12.7.3 - **upgrade to OS occurred last night. My gut tells me something here broke Excel.** Excel version: - Excel for Mac 16.81 (24011420) - Licence: Microsoft 365 Subscription I have used far bigger spreadsheets before today with no issue! Any ideas? I have tried: 1. clearing content of rows below, 2. copying data to a new spreadsheet 3. rebooting. All to no avail. The moment I try and enter or paste new data and hit enter in a cell I get this issue. A screenshot is here Others can open and add data with no issues on other hardware - probably Windows users - I shared spreadsheet internally with my colleagues in Teams. I also tried contacting Microsoft Support - but gave up after about 20 min - when I Googled the response time was 2-6 hours! I also ferreted around looking for answers in Excel log files located in this folder - nothing jumped out at me: - /Users/___/Library/Containers/com.microsoft.Excel/Data/Library/Logs/Diagnostics/EXCEL - ___ - substitute your login id for folder name. I also posted here too. Finally: - there was a UiPath forum post that came up in my search - which in turn had an embedded link here . But neither of these made any sense to me.
Asked by JGFMK (159 rep)
Jan 30, 2024, 01:07 PM
Last activity: Jan 31, 2024, 08:26 AM