LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Excel cannot complete this task with available resources. choose less data or close other applications

Hi,

I am using excel workbook to create report.

Steps:

I am having one excel template which contain more than 25 worksheets.
Using one program to write down csv data into excel. My template
contain macro code also. When user open report macro will execute and
csv data get processed and diferent report will get generate.

My problem is, one csv file contain large data in one cell (around
7K). When I am trying to open excel file i m getting following error:

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


Now what I tried:

1. Reduced data in the cell and ran the report and its working fine.
2. Deleted some worksheets from the workbook and tried its working
fine.

First i think its might be due to more data in cell but when i kept
all data and just delete some sheets its working fine. I m not sure
whats the problem. even my sheets does not contain any formulas.

Can anyone suggest any solution or cause of this problem.


Thanks in advance
Ashish

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel cannot complete this task with availible resources SACoull Setting up and Configuration of Excel 1 October 30th 09 10:16 AM
Excel cannot complete this task with available resources PSM[_15_] Excel Worksheet Functions 1 June 12th 09 11:26 PM
Excel cannot complete this task with available resources. Ali Excel Worksheet Functions 2 August 1st 08 07:49 AM
Excel can not complete this task with available resources. Choose less data or close other applications. [email protected] Excel Discussion (Misc queries) 1 November 12th 06 10:56 AM
Excel cannot complete this task with available resources. ChopperChand Excel Discussion (Misc queries) 0 April 20th 06 04:21 PM


All times are GMT +1. The time now is 06:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"