Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Duke Carey
 
Posts: n/a
Default

If you have it, consider MS Access as the repository for your data, then use
Excel's ability to query an external database to pull in subsets of data on
which to do your analysis.



"Niner" wrote:

I need to bring in data that exceeds the limit of 65,536 rows. Does anyone
know how to expand this limitation?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I increase the limit on the number of import rows in Excel Aleck Excel Discussion (Misc queries) 2 March 18th 05 07:53 PM
the limit on how many rows can be in one spreadsheet liz Excel Worksheet Functions 2 March 4th 05 11:29 AM
Increase rows in worksheet beyond 65,536 row limit Ann Calantzis Excel Discussion (Misc queries) 2 February 25th 05 01:33 PM
How do I limit number of rows and columns on a spreadsheet Valser New Users to Excel 3 February 12th 05 10:31 PM
How do I limit the number of rows in an Excel worksheet. laforge27 Excel Worksheet Functions 1 November 4th 04 01:42 AM


All times are GMT +1. The time now is 03:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"