That accursed Excel >.<

Automatic_Slave · 09-12-2008, 07:50 AM

I'm rather sorry to say I'm an IT Technician in training who's in some serious need of Excel help. I'm more than a little befuddled by my problem.

I've tried searching the net but to no avial, none of the advice I've found seem to be able to fix my problem.

A colleague of mine, who seems to have a re-ocurring problem in Excel is getting more than a little frustrated by the fact she can't get anything done. I've tried and searched, but hey, I'm still new at this, so I thought it was time to ask for help.

Here's the issue:

"Excel cannot complete this task with available resources. Choose less data or close other applications"

Some of you may already be familiar with this error message.

Basically, everytime she opens an invoice this error message appears and more often than not, will actually crash her computer or cause her to lose work. It isn't just on her computer either, it happens on mine as well (Which has a different OS, Excel Version and overall Spec)

Each time an invoice is opened, this message appears (even on files smaller than 30kb)
The invoice is usually, between 40-80kb in size, they are not large files.
The invoices do not contain any type of over complicated fomulae just mostly simple add, subtract, percentage etc
It occurs for several users, each with different spec (Yeah, we should probably standardize ¬_¬)
There is no strain on the PCs resources, nor is there a problem with Excel's internal resource needs

Help, advice or a little push in the right direction would be appreciated. Anything to help me learn some more :3

Thanks x

UPDATE: We're using both Excel 2003 and Excel 2007. PC specs are varied, being Windows XP SP3 to Windows Vista SP1. Most machines have between 1-2 gig of RAM.

Elkar · 09-12-2008, 02:18 PM

Does this error occur only with this particular "Invoice" workbook? Does the workbook have any macros or VB code? I would take a look at that first. Particularly any "Workbook_Open" events.

HTH
Elkar

TheGift73 · 09-12-2008, 02:48 PM

Have you got Office XP SP3 installed?

Follow the link as it has some information regarding your problem. Hope this helps.

Automatic_Slave · 09-15-2008, 01:55 AM

The error occurs in about 98% of the invoices that are opened and trust me, that's a hefty amount. We make invoices for each of our clients every week so they well into the thousands, if not tens of thousands. As I said, there's nothing overly swanky about them, just a few relatively simple formulas so no macros or VB code.

Thanks for the link, but I've had that up myself in pursuit of an answer and to no avail T.T

We're using a mixture of 2003/2007 but the problem occurs on both.

Thanks for the comments guys xxx

09-12-2008, 07:50 AM	#1 (permalink)
Automatic_Slave Registered User Join Date: Sep 2008 Location: Manchester, UK Posts: 7 OS: Windows Vista SP1	That accursed Excel >.< I'm rather sorry to say I'm an IT Technician in training who's in some serious need of Excel help. I'm more than a little befuddled by my problem. I've tried searching the net but to no avial, none of the advice I've found seem to be able to fix my problem. A colleague of mine, who seems to have a re-ocurring problem in Excel is getting more than a little frustrated by the fact she can't get anything done. I've tried and searched, but hey, I'm still new at this, so I thought it was time to ask for help. Here's the issue: "Excel cannot complete this task with available resources. Choose less data or close other applications" Some of you may already be familiar with this error message. Basically, everytime she opens an invoice this error message appears and more often than not, will actually crash her computer or cause her to lose work. It isn't just on her computer either, it happens on mine as well (Which has a different OS, Excel Version and overall Spec) Each time an invoice is opened, this message appears (even on files smaller than 30kb) The invoice is usually, between 40-80kb in size, they are not large files. The invoices do not contain any type of over complicated fomulae just mostly simple add, subtract, percentage etc It occurs for several users, each with different spec (Yeah, we should probably standardize ¬_¬) There is no strain on the PCs resources, nor is there a problem with Excel's internal resource needs Help, advice or a little push in the right direction would be appreciated. Anything to help me learn some more :3 Thanks x UPDATE: We're using both Excel 2003 and Excel 2007. PC specs are varied, being Windows XP SP3 to Windows Vista SP1. Most machines have between 1-2 gig of RAM. Last edited by Automatic_Slave; 09-12-2008 at 08:15 AM.

09-12-2008, 02:18 PM	#2 (permalink)
Elkar Registered User Join Date: Mar 2008 Posts: 69 OS: XP SP2, Vista	Re: That accursed Excel >.< Does this error occur only with this particular "Invoice" workbook? Does the workbook have any macros or VB code? I would take a look at that first. Particularly any "Workbook_Open" events. HTH Elkar

09-12-2008, 02:48 PM	#3 (permalink)
TheGift73 Registered User Join Date: Oct 2006 Location: Lewes UK Posts: 151 OS: XP Pro SP3 My System	Re: That accursed Excel >.< Have you got Office XP SP3 installed? Follow the link as it has some information regarding your problem. Hope this helps.

09-15-2008, 01:55 AM	#4 (permalink)
Automatic_Slave Registered User Join Date: Sep 2008 Location: Manchester, UK Posts: 7 OS: Windows Vista SP1	Re: That accursed Excel >.< The error occurs in about 98% of the invoices that are opened and trust me, that's a hefty amount. We make invoices for each of our clients every week so they well into the thousands, if not tens of thousands. As I said, there's nothing overly swanky about them, just a few relatively simple formulas so no macros or VB code. Thanks for the link, but I've had that up myself in pursuit of an answer and to no avail T.T We're using a mixture of 2003/2007 but the problem occurs on both. Thanks for the comments guys xxx