[ms office - 2013] Sisra/Progresso Crashing Excel

[reltihmd]

Good Morning

 

We have Windows 8.1 (64 bit)/Office 2013

 

For some time now, our data manager has suffered randomly with the following error message in excel

 

There isn't enough memory to complete this action. Try using less data or closing other applications. To increase memory available, consider using a 64bit version of Excel / Adding memory to your device

 

The machine in question is a Core i5 with 8GB Ram (this was an upgrade shortly after the problem started), so isn't really being taxed with excel.

 

We've tried a few things to solve this - most recently biting the bullet and installing 64 bit Office

 

This has not resolved the issue, so we are now adding another 8GB Ram to the machine that I'm sure isn't going to fix it

 

One comment we've seen online is that poorly written add ons for excel can cause this issue. Our data manager works with both Progresso and Sisra Add ons that other people onsite probably do not use

 

Progresso and Sisra support both deny that their add ons could be causing this

 

Has anyone else seen this problem with either of these two systems, alternatively has anyone resolved this problem successfully by doing anything else - please let me know

[NickBuckel]

Hi @reltihmd,

 

You mention that this is happening on your data manager's PC, have you tried using a different PC to see if you get the same issue - could it be something about their PC/profile? Progresso doesn't have an add-on for Excel, but it might be worth disabling any add-ons you do have to see if doing that fixes the issue - you can then enable them one at a time to see which one is causing the problem.

 

I'm happy to take a look at the file to see if I can see anything that might cause the error if you want to PM me.

 

Kind Regards,

 

Nick

[reltihmd]

Hi Nick - thanks for responding, we have swapped out the PC and cleared the profile previously and neither has helped. Unfortunately the error seems random (and given the lack of replies - fairly unique to us)

 

increasing the memory in the machine didn't fix the problem and we have now disabled the Sisra add on to see if this helps

 

I'll update this post as to our results

[Oaktech]

I've seen this before, but a profile reset fixed it for us... Sorry to here it's not for you. I'd get Advanced Learning on the case!

[reltihmd]

Thanks Oaktech - it's looking more and more like it's not a progresso issue though as we have now replicated it with non progresso data - still testing the Sisra plugin though and will update everyone ASAP