large data file

  1. B

    Excel Freezing on doing any Action

    Hello All I have a very large excel file with 7 million records and 45 MB in size and on doing any action like deleting column, my excel is freezing and it takes a long time to complete that action. Is there any way to make these actions on excel quicker. Thanks in Advance.
  2. J

    Published Webpage Suddenly very large

    Good Day I have a spreadsheet with multiple tabs. 3 of the tabs are created as dashboards and saved as a web page with the option to auto republish every time I save it. A week ago I added some new info on one of the dashboards. Ever since I did that the size of the dashboard is so big that...
  3. S

    How to handle large data sets (180 MB file)

    Hey guys our company uses MS Office 2010. We have a 180 MB excel file that imports all our sales data from our ERP via MS query, as well as links to other external Excel spreadsheets to gather company data It constantly crashes despite rebooting multiple times and gives error messages such as...

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