Introducing G2.ai, the future of software buying.Try now
  1. Home
  2. ...
  3. Spreadsheets Software
  4. Microsoft Excel
  5. Microsoft Excel Discussions
  6. How to reduce time while opening large data workbooks of 800 MB
Naveed Ahsan J.
NJ
Monitoring & Control Officer | Passionate about Data Science
Expand/Collapse Social Share Options

How to reduce time while opening large data workbooks of 800 MB

I work as a data analyst and have to encounter difficulty everyday regarding large data files of almost 800 MB and it takes quite a lot of time to open and my precious time is lost because of that if there is any shortcut to open data quickly kindly share
2 comments
Looks like you’re not logged in.
Users need to be logged in to answer questions
Log In
George A.
GA
School Information System Administrator at Champville
0
Just to be clear on something: I am COMPLETELY AGAINST having large data files for multiple reasons, data loss because of a faulty connection or hardware failure being the two main ones. If you are not considering creating multiple files and connecting them via primary/secondary keys, then I strongly advise you to either a) stop saving as XLS/XLSX and use XLSB instead (EXCEL BINARY), or, b) switch to XML. These are the only two propositions I can think of, short of switching to a SQL database.
deleteedit
Looks like you’re not logged in.
Users need to be logged in to write comments
Log In
Reply
Elton S.
ES
--
0
I work as a data analyst and have to encounter difficulty everyday regarding large data files of almost 800 MB and it takes quite a lot of time to open and my precious time is lost because of that if there is any shortcut to open data quickly kindly share
deleteedit
Looks like you’re not logged in.
Users need to be logged in to write comments
Log In
Reply
Already have Microsoft Excel?

About Microsoft Excel

Discover More