Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Are there limits on Pivot Charts and Tables
Hi,
I recently developed a Pivot Chart and Table that analyses some keys statistics for our organisation. Each week I add data to the source file which is an external *.csv file. The data is averaged by item by hour...we now have over 3 months of data and around 1.4 million recoreds within the *.csv file being processed. In the most recent week I added some further records and when loading the updated source file it returns the excel message that the data cannot be retreived as Excel does not have sufficient resources....choose less data. I have seen other posts about memory restrictions on Excel limiting the amount of data that can be utilised in a pivot table or chart.. At our organisation the Excel version is 2002.. Is there any alternatives to this problem that do not involve summarising the data further and losing information ? Would converting the *.csv file into an external database resolve the problem Thanks for any assistance or advice |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Are there limits on Pivot Charts and Tables
At 1.4Million records you have probably rung the bell on the memory. Your
best bet is to use something like Analysis Services in SQL server or Essbase. You can do Cross Tab queries in Access and such but they are not nearly as flexible. -- HTH... Jim Thomlinson "scott56hannah" wrote: Hi, I recently developed a Pivot Chart and Table that analyses some keys statistics for our organisation. Each week I add data to the source file which is an external *.csv file. The data is averaged by item by hour...we now have over 3 months of data and around 1.4 million recoreds within the *.csv file being processed. In the most recent week I added some further records and when loading the updated source file it returns the excel message that the data cannot be retreived as Excel does not have sufficient resources....choose less data. I have seen other posts about memory restrictions on Excel limiting the amount of data that can be utilised in a pivot table or chart.. At our organisation the Excel version is 2002.. Is there any alternatives to this problem that do not involve summarising the data further and losing information ? Would converting the *.csv file into an external database resolve the problem Thanks for any assistance or advice |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Are there limits on Pivot Charts and Tables
Thanks....I had hoped to be able to keep the use of Excel as the report
provider and thereby limit the need for any other software on the PC for the users Scott "Jim Thomlinson" wrote: At 1.4Million records you have probably rung the bell on the memory. Your best bet is to use something like Analysis Services in SQL server or Essbase. You can do Cross Tab queries in Access and such but they are not nearly as flexible. -- HTH... Jim Thomlinson "scott56hannah" wrote: Hi, I recently developed a Pivot Chart and Table that analyses some keys statistics for our organisation. Each week I add data to the source file which is an external *.csv file. The data is averaged by item by hour...we now have over 3 months of data and around 1.4 million recoreds within the *.csv file being processed. In the most recent week I added some further records and when loading the updated source file it returns the excel message that the data cannot be retreived as Excel does not have sufficient resources....choose less data. I have seen other posts about memory restrictions on Excel limiting the amount of data that can be utilised in a pivot table or chart.. At our organisation the Excel version is 2002.. Is there any alternatives to this problem that do not involve summarising the data further and losing information ? Would converting the *.csv file into an external database resolve the problem Thanks for any assistance or advice |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
charts and pivot tables | Charts and Charting in Excel | |||
Pivot charts & tables | Charts and Charting in Excel | |||
Pivot tables Charts | Excel Discussion (Misc queries) | |||
Pivot Tables and Charts | Charts and Charting in Excel | |||
Pivot Charts / Tables | Excel Worksheet Functions |