Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot link to database
I currently have an Excel pivot that's linked to an external Access
database. The DB table contains over 1 million records. This causes Excel to use about 1GB in memory. If I port the Access DB to MS SQL and link the pivot to a cube file, would this reduce the memory used by the pivot (and maybe even speed up the refresh)? Or, is there another way that might help reduce the memory required? TIA... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Link to SQL Database | Excel Worksheet Functions | |||
link excel database? | Excel Discussion (Misc queries) | |||
Moved database, how do I change link to the database in excel | Excel Discussion (Misc queries) | |||
Database Link | Excel Discussion (Misc queries) | |||
Removal of link to database | Excel Discussion (Misc queries) |