Alternative for large data reporting
I have to do a financial report from a large Excel data file with roughly 300K lines x 60 columns. My Excel keeps crashing or running extremely slow especially when running Pivot charts with Slicers. Is there another way to resolve this large data issue beside MS Access. I can't wait for multiple layers approval to purchase the MS Access licenses.
We would have to see a sample of the file with just enough Rows to see what variations there are in values. Please obfuscate any personal or proprietary information. Also give us a sample of what the output file should look like, with notes as to where the data came from in the other sample.
To upload or Attach files to your posts, use the "Go Advanced" button and below the Editor, you will see a "Manage Attachments": button which lets you browse for and elect files to attach.
You will need to make, IIRC, at least 5 posts before you can upload files. Start by giving us some more details about your data files and the desired outputs.
I expect the student to do their homework and find all the errrors I leeve in.
Please take the time to read the Forum FAQ
Making the PT?Originally Posted by tcambridge
Refreshing the PT or Chart?
Something else?
---------------------------------------------------------------------------------------------------------------------
Paul
Remember: Tell us WHAT you want to do, not HOW you think you want to do it
1. Use [CODE] ....[/CODE ] Tags for readability
[CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
2. Upload an example
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
3. Mark the thread as [Solved] when you have an answer
Thread Tools (on the top right corner, above the first message)
4. Read the Forum FAQ, especially the part about cross-posting in other forums
http://www.vbaexpress.com/forum/faq...._new_faq_item3
Reply With Quote
