I have 500,000 rows of data on a sheet that is taking long time to process since there are some formulas and conditional formatting etc. also this data is forecasted to cross over 1 million rows in near future. I know excel does not support anything in excess of million so what are my options?
Where should I store the database so I can only extract relevant information based on queries
Please advise
Thanks
- Excel with PowerQuery
- Access
- SQL / Orcale or any other...
...- Cray computer
Last edited by sandy666; 05-28-2018 at 04:20 PM.
thanks for your reply.
how does excel with power query works? can it accommodates over 1 million rows?
AFAIK PQ doesn't have limitation except RAM and HD
What PowerQuery is? see here: Getting Started with PowerQuery (Get&Transform) in Excel
correction: Power Query specifications
thanks for your reply
you are welcome
have a nice day
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks