Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002 performance
I'm running into really bad performance problems with Excel 2002.
Problem 1: - Have a workbook with multiple worksheets approx 145MB and now approaching 63,000 lines. Excel often "cannot complete with available resources", can only paste limited data to clipboard even when empty, cannot sort or - in some cases - filter. Problem 2: - more intriguing; I have a text file created from another application that's only 50MB, also 63,000 lines with 30 columns, that takes an hour to open. I'm using a Dell Latitude D600, 1.6GHz processor with 2GB RAM, so memory's not a problem. Does anyone have any advice and/or know if Excel 2007 will perform better? -- RP |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002 performance
Check to see if index service is operating. The can easily be checked in the
Task Manager. Look for CISVC.exe. Try killing process and see if the file opens any quicker. Index service is suppose to speed up opening files but in some cases it slows things down considerably because Indexing uses a lot of memory. If you do a search on the web for Indexing and CISVC.exe you find a lot of information. "Robin P" wrote: I'm running into really bad performance problems with Excel 2002. Problem 1: - Have a workbook with multiple worksheets approx 145MB and now approaching 63,000 lines. Excel often "cannot complete with available resources", can only paste limited data to clipboard even when empty, cannot sort or - in some cases - filter. Problem 2: - more intriguing; I have a text file created from another application that's only 50MB, also 63,000 lines with 30 columns, that takes an hour to open. I'm using a Dell Latitude D600, 1.6GHz processor with 2GB RAM, so memory's not a problem. Does anyone have any advice and/or know if Excel 2007 will perform better? -- RP |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002 performance
Not having Excel 2007 yet, I don't know if it would handle this better, I
suspect it would though. In the older versions which I use too, a file of 145MB and 63,000 lines I think is pushing it. Presumably most of the file is data which is stored and a relatively small amount is taken up with formulas, pivots, graphs etc. I may be wrong but I've always understood that Excel should be used for calculations etc and not as a database. If you stored the static data in Access for instance and had Excel refer to an Access file instead of storing it all in the Excel file itself you may get better results. I'm making assumptions here as to what is in your huge file I know. If I'm wrong, please just ignore this, Regards, Alan. "Robin P" wrote in message ... I'm running into really bad performance problems with Excel 2002. Problem 1: - Have a workbook with multiple worksheets approx 145MB and now approaching 63,000 lines. Excel often "cannot complete with available resources", can only paste limited data to clipboard even when empty, cannot sort or - in some cases - filter. Problem 2: - more intriguing; I have a text file created from another application that's only 50MB, also 63,000 lines with 30 columns, that takes an hour to open. I'm using a Dell Latitude D600, 1.6GHz processor with 2GB RAM, so memory's not a problem. Does anyone have any advice and/or know if Excel 2007 will perform better? -- RP |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002 performance
you can find advice on both memory/resource problems and calculation
optimisation at my website. Charles ______________________ Decision Models FastExcel 2.3 now available Name Manager 4.0 now available www.DecisionModels.com "Robin P" wrote in message ... I'm running into really bad performance problems with Excel 2002. Problem 1: - Have a workbook with multiple worksheets approx 145MB and now approaching 63,000 lines. Excel often "cannot complete with available resources", can only paste limited data to clipboard even when empty, cannot sort or - in some cases - filter. Problem 2: - more intriguing; I have a text file created from another application that's only 50MB, also 63,000 lines with 30 columns, that takes an hour to open. I'm using a Dell Latitude D600, 1.6GHz processor with 2GB RAM, so memory's not a problem. Does anyone have any advice and/or know if Excel 2007 will perform better? -- RP |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002 performance
Not running so didn't help, but will keep an eye out for the future. Thanks.
-- RP "Joel" wrote: Check to see if index service is operating. The can easily be checked in the Task Manager. Look for CISVC.exe. Try killing process and see if the file opens any quicker. Index service is suppose to speed up opening files but in some cases it slows things down considerably because Indexing uses a lot of memory. If you do a search on the web for Indexing and CISVC.exe you find a lot of information. "Robin P" wrote: I'm running into really bad performance problems with Excel 2002. Problem 1: - Have a workbook with multiple worksheets approx 145MB and now approaching 63,000 lines. Excel often "cannot complete with available resources", can only paste limited data to clipboard even when empty, cannot sort or - in some cases - filter. Problem 2: - more intriguing; I have a text file created from another application that's only 50MB, also 63,000 lines with 30 columns, that takes an hour to open. I'm using a Dell Latitude D600, 1.6GHz processor with 2GB RAM, so memory's not a problem. Does anyone have any advice and/or know if Excel 2007 will perform better? -- RP |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002 performance
Yes, there's a lot of data but also a lot of calculations, pivots and
transformations. However, I think you're right that it's time to use Access for some or all of the functions, even though it's less convenient and I don't speak the language (yet). -- RP "Alan" wrote: Not having Excel 2007 yet, I don't know if it would handle this better, I suspect it would though. In the older versions which I use too, a file of 145MB and 63,000 lines I think is pushing it. Presumably most of the file is data which is stored and a relatively small amount is taken up with formulas, pivots, graphs etc. I may be wrong but I've always understood that Excel should be used for calculations etc and not as a database. If you stored the static data in Access for instance and had Excel refer to an Access file instead of storing it all in the Excel file itself you may get better results. I'm making assumptions here as to what is in your huge file I know. If I'm wrong, please just ignore this, Regards, Alan. "Robin P" wrote in message ... I'm running into really bad performance problems with Excel 2002. Problem 1: - Have a workbook with multiple worksheets approx 145MB and now approaching 63,000 lines. Excel often "cannot complete with available resources", can only paste limited data to clipboard even when empty, cannot sort or - in some cases - filter. Problem 2: - more intriguing; I have a text file created from another application that's only 50MB, also 63,000 lines with 30 columns, that takes an hour to open. I'm using a Dell Latitude D600, 1.6GHz processor with 2GB RAM, so memory's not a problem. Does anyone have any advice and/or know if Excel 2007 will perform better? -- RP |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002 performance
I'd checked your website before posting and not found anything there; but
thanks for the reply. -- RP "Charles Williams" wrote: you can find advice on both memory/resource problems and calculation optimisation at my website. Charles ______________________ Decision Models FastExcel 2.3 now available Name Manager 4.0 now available www.DecisionModels.com "Robin P" wrote in message ... I'm running into really bad performance problems with Excel 2002. Problem 1: - Have a workbook with multiple worksheets approx 145MB and now approaching 63,000 lines. Excel often "cannot complete with available resources", can only paste limited data to clipboard even when empty, cannot sort or - in some cases - filter. Problem 2: - more intriguing; I have a text file created from another application that's only 50MB, also 63,000 lines with 30 columns, that takes an hour to open. I'm using a Dell Latitude D600, 1.6GHz processor with 2GB RAM, so memory's not a problem. Does anyone have any advice and/or know if Excel 2007 will perform better? -- RP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002: How is the Excel 2007 file format open in Excel 2002 ? | Excel Discussion (Misc queries) | |||
Excel 2002 : Unable to open files in MS Outlook 2002 | Excel Discussion (Misc queries) | |||
Outlook 2002 calendar dates exported to Excel 2002 sort incorrectl | Excel Worksheet Functions | |||
Excel Performance issue | Excel Discussion (Misc queries) | |||
Can you print labels using Excel 2002 in a Word 2002 mail merge? | Excel Discussion (Misc queries) |