Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I put the do not call list in excel...does not fit
Hi...
Trying to download "Do Not Call" list for my state into Excel....too large to fit full file...is there a way around this? Would like it to be in columns and all fit! Thanks much! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I put the do not call list in excel...does not fit
In my version of Excel (Excel 2003) the maximum rows allowed in 65,536.
(I've seen references to greater amounts in subsequent or future versions, but it sounds like you're using this version or something similar as well.) Since the do not call list is likely to be pretty large, in terms of a row count, you'll either need to expand into different columns, or spread it across multiple tabs in the workbook, or use a database, which would have no such row restrictions. What do you need to do with the data? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I put the do not call list in excel...does not fit
Use Access or another db package.
Excel has a limit of 65000 rows (at least in the current version. XL 2007 is a different story.) -- Brevity is the soul of wit. "scorm" wrote: Hi... Trying to download "Do Not Call" list for my state into Excel....too large to fit full file...is there a way around this? Would like it to be in columns and all fit! Thanks much! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you find the list option in excel on office xp | Excel Worksheet Functions | |||
Excel e-mail list to netscape | Excel Discussion (Misc queries) | |||
Excel 2003 list of field codes for footers? | Excel Discussion (Misc queries) | |||
Get excel to list values that occur within raw data | Excel Discussion (Misc queries) | |||
Excel List range, filter arrows disappeared | Excel Discussion (Misc queries) |