System Error &H80004005 (-2147467259).

[Welshbird]

I occasionally get this message appearing, at which point Excel closes, and much though it recovers anything in the spreadsheet it loses any VBA I've written.

Yesterday this lost me 3 and a half hours of work. Boo as they say...

I've discussed with my IT department, and they don't really know why this happens. We ran a check on my physical machine overnight, just in case in was the memory or something (which it seems not to be) but all I can find when I Google says this is a 'stack overflow'.

The models I'm working with are all rather small, and in fact yesterday when this happened I only had 6 cells with data.

I'm trying to make myself be more disciplined in clicking the save button, but any other thoughts would be extremely welcome right now.

(As an aside - is there any way to get my VBE to autosave regularly? That might at least be a work-around for the problem.)

Oh, no pattern to when this happens - nothing in the event log either, so we're all clueless over here.

Thanks chaps.

Fee

"The cure for anything is salt water – sweat, tears, or the sea." Isak Dinesen

 

[Welshbird]

Bump, and nope. Still going on.

So, now rebuilt as 32bit op and office - still 'out of memory' eorr - randomly.

So, I've decided that potentially XLCubed might be the culprit here, so have removed it.

So far so good, but then the random nature means I can't tell yet....

Here'shoping though!

Fee

"The cure for anything is salt water – sweat, tears, or the sea." Isak Dinesen

 

[Welshbird]

Bump, and nope. Still going on.

So, now rebuilt as 32bit op and office - still 'out of memory' eorr - randomly.

So, I've decided that potentially XLCubed might be the culprit here, so have removed it.

So far so good, but then the random nature means I can't tell yet....

Here's hoping though!

Fee

"The cure for anything is salt water – sweat, tears, or the sea." Isak Dinesen

 

[Welshbird]

Bump, and nope. Still going on.

So, now rebuilt as 32bit op and office - still 'out of memory' eorr - randomly.

So, I've decided that potentially XLCubed might be the culprit here, so have removed it.

So far so good, but then the random nature means I can't tell yet....

Here'shoping though!

Fee

"The cure for anything is salt water – sweat, tears, or the sea." Isak Dinesen

 

[N1GHTEYES]

Is there an echo in here?

 

[strongm]

> I've decided that potentially XLCubed might be the culprit

Which I may have said a while ago ...

 

[Welshbird]

You did, but we don't have another cube viewer.....

Hope this is all working then thought isn't it.

As I say, so far so good.

Fee

"The cure for anything is salt water – sweat, tears, or the sea." Isak Dinesen