Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
general questions regarding reducing file size for pivottables
Hello
I use Pivottables as a "Business Intelligence" and financial reporting tool. Basically what I do is that I import data from our accounting system on transaction level, and then build my reports and analyses on them. My problem is that as the imported data is on transaction-level the file gets very large (10.000-nds of rows and file size about 50 MB). This makes Excel slow and means that I cannot mail the file to my colleagues. I understand that this is because the imported data-amount is so large, so I'm asking for suggestions to reduce this. (In most cases I get data on a more detailed level than I need, for exemple I might get one transaction per day, and that is a information that I don't need) Is this possible within Excel, or should I learn Access and can I solve it there? Kind regards Marcus |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reducing size of a file with no data | Excel Discussion (Misc queries) | |||
Reducing Excel File Size | Excel Discussion (Misc queries) | |||
Reducing a size of the shared excel file | Excel Discussion (Misc queries) | |||
reducing file size | Excel Discussion (Misc queries) | |||
Reducing file size | Excel Discussion (Misc queries) |