Will Intel Optane speed up excel?

Hi All,

I’ve got an interesting problem, I’m currently dealing with excel workbooks 50mb <= with macros. Excel is slow and unresponsive at times, I’m unable to change the excel workbook as it’s supplied by the vendor.

Current PC Specs: AMD 5900x, 32GB DDR4 3600 CL16-16-16-16, Gigabyte Aorus M.2 1TB, MSI 3080ti

Will Optane fix this problem?

I am doubtful it will help if you are already working on any SSD, as the entire workbook should be sitting in ram and the disk of little importance until you hit save.

You can consider setting up a ram disk and using the file from there to tell you if there is any benefit for free.

2 Likes

Implementing Optane helps more so, for ramping up [typically used] programs
If its the file that being a limp dog, you should talk with others, that are also using it
In case its the underpinning macros, that is being clunky- forward complaint to vendor

1 Like

Vendor would tell me to eat a limp dog :slight_smile:

1 Like

Generally curious about this too. Dealing with shit models that are 20MB with links and Macros that take 5 min or so to run. Not to mention the person that created the model has a million different styles.

1 Like

Probably not… First, I would test the ram disk if it will be similar here, there is no point in wasting $.

Here, however, I think more cpu has to say than the disk subsystem, considering that you are not currently operating on very slow I/O. The problem may be the software itself, and you won’t do much with it.

Have you experimented with

Enable Manual Calculation Mode

Disable Excel Add-ins

Are you saying more cores = more better :stuck_out_tongue:

I’ve already disabled as much as I can already, I think it’s down to poor macro coding.

Exactly, in 9 out of 10 cases, this is just poor coding. But there’s not much you can do about it in this situation… :wink:

Apparently, automatic calculation likes to cause temporary hiccups and the first thing people recommend is to go to manual and F9. :wink:

Instead of a thousand cores, personally, I would prefer that the cpu entered a new dimension of the 10/20/30Ghz clock speed, but it will only remain a dream. :slight_smile:

Excel accelerator card when? :upside_down_face:

1 Like

Even if I had the resources to create something like this, I still need to convince the software to work with such an accelerator and this is a big problem. :slight_smile:

1 Like

Don’t apply your logic here or we will cry :cry: haha

I would make a RAMdisk as suggested. That was going to be my suggestion as well. Place the excel file in the RAMdisk and try to open and edit it then. If you dont get any speedup then optane wont help as it is slower than a RAMdisk anyway.

As other said, it is just slow macro coding. You are probably on a single core calculating it from within excel so your CPU having so many cores isn’t really doing much. The only thing that might help is if you had a 5800X3D, the extra cache maybe be able to speed things up. Probably wouldnt help enough o be worth the cost of changing the CPU though.

edit: actually, check about disabling all anti-virus on the PC and see if you get a speedup. Excel Macros is a well known virus vector, so you may be getting some serious slowdown from AV doing stuff with the macro to check it and make sure things are safe.

1 Like

Thanks for the excuse to buy more RAM! 32GB in the mail