I have Office 2010 and the Excel Workbook I am using for poker tracking is at 379K KB. It's incredibly slow to save. I don't think this is a particularly large workbook.

Suggestions?

If you don't have any equations, you can try saving as csv.

Do you mean 379K KB? In other words 379,000KB or 379MB? I assume not, but if you do that is not a small file.

Plus if you are running Excel 2010, it's likely you are on a Win7 or, if at work, a way underpowered PC, which is typical.

I'm not sure all the parameters, but any excel file I used had about a 2 million cell limit before it went down in flames or corrupted, and that's a dense book. A sparse book or macro-enabled was considerably smaller.

The Excel 2010 workbook is 379,000KB and I am on Win 10. OK, I just checked system and here are the stats of this comp.

Dell Inspiron 580
Windows 10 Home
Version 1703
Processor Intel Core i3 CPU 550 @ 3.20 GHz
Installed RAM 6.00 GB
64-bit
Storage: 148 GB used out of 917 GB

I haven't had any problems with this comp and while old (not sure how old), it delivers on everything I need. This the first issue I have had with it.

That file is huge. Are you saying you've been using this file, at this size, for a while and it just now started going slow?

Yep, that is an enormous file for Excel. How many lines of data is it? Do you have images or other items embedded in it rather than just text? Often it is the content rather than the size that matters, but Excel can get fussy with files of 20MB or more, never mind 379MB.

All of the above.

You can try disabling auto update but I doubt that's going to help. It's probably time to slim down your file.

Nope, it's 379,000 KB and just text. So that is 379 MB, right?. So I guess it's getting fussy? But I really don't have that much data in there. Hard to believe it can't handle this. Is this a memory issue?

I am checking Memory Usage with the Excel file open:

In use 5.1 GB Available 777 MB

Do you need other data?

379MB is a ton of data if it's just text. I'm struggling to understand how your file can be that size. How many rows/cells etc is it?

Also, what other programs are using your memory? How much is Excel using?

Deleted an entire sheet of this workbook that used a lot of rows, but not really much text.

Excel is now using 19.9 MB Memory, with just this workbook open. It looks like 76% of Memory is being used in total.

Using A through R and 91 rows on one sheet, A through J and 66 rows on another, and A through AF and 32 rows on the third sheet, which is just three charts of my poker hand ranges.

Saving much faster now!

Well, that's progress.

But 19.9MB? That's under half a per cent of your 6GB. So what is using the other 4.5GB? Open Task Manager and click the percentage at the top of the Memory column to sort by that column. What programs appear at the top and how much is each using?

(Also, you're now talking about charts. That doesn't sound like plain text to me, and will make a difference to how Excel functions. Same goes for whatever was in that sheet you deleted that wasn't text.)

Yeah, sparse data is a killer on Excel. Your data should be reasonably dense. Blank rows is a killer as well.

I'm also struggling to know how "not that much data" gets you up to 379MB. I've created product catalogs in Excel that are nowhere near that size.

If you are using a lot of hotkeys, like highlight row or highlight column, Excel is saving blanks in all of that. Go to the end of your columns, highlight all things to the right, right-click and select "delete columns" or "delete data." Can't recall the exact thing. Do the same for the rows. This is usually a good way to clean up bloated invisible data.

It may be a good time to uninstall a lot of programs. If not, at least stop programs from starting on startup:

https://www.howtogeek.com/74523/how-...ms-in-windows/

You have to be little careful with this.

This sounds pretty small.

All of the largest Memory users are Google Chrome. I have 6 tabs open and that is more or less what I usually have open at the same time. These range from 46 MB to 279 MB. iTunes is 119 MB, but it is not open and is not a Startup. While there are a lot of other things listed, they are below 20 MB.

Startup High Impact: iTunes Helper; Microsoft OneDrive. Medium Impact: Adobe Updater Startup Utility; GoogleToolbarNotifier; Logitech Download Assistant; Realtek HD Audio Manager; SearchEngineProtection.exe. Several others Not Measured.

I am using formulas in cells, but no hotkeys.

I rarely shut the comp down. I tend to have a lot of browser windows open and figure I'd keep them open rather to whatever I was looking at/streaming, than shut down the comp every night. Bad?

Whether you are using hotkeys or not, try deleting all the data in the blank cells using the technique I described.

I don't see anything to the right of the last column I am using. There is no data in there at all, never was, just blank cells. Anything to the right of the last column I am using, would just go on to the last column on the sheet. Not sure how to delete all of them.

Highlight all the blank cells, right click, and select delete data. Excel often carries a ton of invisible data, and I'm telling you how to get rid of it.

Just do it.

6 instances of Chrome all smaller than 279MB don't add up to anything near the 4.5GB of RAM that you reported was in use. Next time you see more than say 3GB of RAM in use, check what programs are using it.

In the meantime the "searchengineprotection.exe" in your startup items seems to be a program called GamesBar by Oberon Media. This gets mixed reviews at best, and seems that it may be adware if not worse. Unless you are really wedded to this program you could uninstall it.

It's not the end of the world to keep browser tabs open, but if they're all streaming things that's probably not helping your resource management.