View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] ashish.kare@gmail.com is offline
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