large datasets

  1. R

    Storing data sets too large for Excel in Access

    Hello, I have a huge binairy workbook which calculates the financial forecast. This file is too big for its own good (21mb). I was wondering how to solve this. I thought of two possibilities: Create multiple workbooks which calculate a part of the operation. Then, when it’s done VBA can...
  2. U

    "The text file contains more data than will fit on a single worksheet"

    Hey everyone! I am trying to load a dataset with approximately 3,500,000 data points. It is a comma separated text file. When I try this comes up: How do I do this? There is no exclude data option when I start the import again in a different worksheet. I did, however, try changing the...
  3. M

    Excel Front end to HUGE dataset -- Best options?

    So I recognize that this is not Excel's primary function, but I have created a dashboard using various pivot tables, pivot charts, and slicers in Excel. The dashboard is visually appealing and exquisitely functional. Importantly, it can be used by anyone on my network with base Excel...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top