Email:      Pass:    Pass?
Close Window   
Free Ebook
Get Your Free Excel
ebook!
Our Top 15 Excel Tutorials
Instant Access!
E-mail:
Subscribe for Free Excel tips & more!
E-mail:
Advertisements



How To Increase Maximum Number Of Columns In Excel 2003

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

Excel 2003 is set to 256 columns, perhaps because my spreadsheet was
originally started in Excel 97. How can I increase the maximum number of
columns to what is possible in Excel 2003? Quattro Pro has far more columns
available. I can't believe that Microsoft would limit Excel 2003 to 256
columns. ?????


View Answers     

Similar Excel Tutorials

Quickly Create a Huge List of Numbers in Excel
Quickly create a large list of numbers in Excel using the Fill Command.  This will save you time and allow you to ...
Quickly Resize Multiple Columns or Rows at Once in Excel
How to quickly resize multiple columns and rows at once in Excel.  This avoids having to individually resize rows ...
Delete Duplicate Values in All Versions of Excel
How to delete duplicate values from a data set in all versions of Excel.  This includes Excel 2003 and earlier and ...
Scale Data for Printing in Excel - Fit more onto a Printed Page
This tip shows you how to fit more Excel data onto a page for printing. This does not change the size, shape, or lo ...

Helpful Excel Macros

Filter Data Sets on Multiple Columns with Multiple Criteria at Once in Excel - AutoFilter
- This Excel macro allows you to filter a data set on multiple columns and criteria at once. This means that you can filt
Delete Empty Columns
- This macro will delete columns which are completely empty. This means that if there is no data within the entire column
Reverse Row or Column Order in a Worksheet
- This macro reverses the order of a selected row or column in excel. It will completely reverse the data.
Make Text to Uppercase
- This macro will change all text within the selected cells to uppercase. It works only on selected cells within Microsoft
Change Text to Lowercase
- This macro will change all text within the selected cells to lowercase. It works only on selected cells within Microsoft

Similar Topics







Dear All,

Prior to Excel 2007, you could only sort by at most three levels using the dialog box. If using VBA for Excel 2003, is the maximum number of levels still three? I need to sort by six columns. Do I need to sort by columns 4 through 6, and then by 1 through 3 to get the desired effect?

Thanks,

GL


Is there a way to increase the maximum number of columns in Excel 2010 beyond column IV? I know excel lists this as the maximum number of columns, but I do not know if anyone has a work around to that would allow for more columns to be added?


Hi Guys,
Briefly, I run a spreadsheet that pulls in financial data from a provider(Bloomberg) and ranks trades according to parameters I set. It compares each stock to each other; therefore with excel 2003 I could enter a maximum of 255 stocks(255^2=65025). If I programmed any more stocks I would get an "exceed number of rows limit"

On Friday I installed Excel 2007. This has 1m rows allowing me to increase my securities sample set to 1000(1000^2=1m).

However when I run this it completes 9% of the calculations before I get an error message. This states "exceeds maximum number of rows 65k". I then get a VISUAL BASIC "run time error 9, subscript out of range message"

It seems that the programme does not realise that I am now running excel 2007. I have saved the sporeadsheet in excel2007(as a .xlsm) and I open it in Excel 2007. I have no idea why it is still giving me a row limit message...

Any Ideas or input would be greatly appreciated...

Thanks


Hi Can any one tell me how to limit the number of columns in an excel 2003 spreadsheet, I only want columns a-g to be displayed and no others, I know it can be done but can't figure out how, any help would be much appreciated.


I have a .csv file I'm importing into Excel. It has 150 columns. My VBA code that shows the columns being imported wraps with the line continuation underscore character _. When I run the code, I get a message, something about the maximum number of continuation characters being exceeded. I don't have the code, nor the exact error message with me. I think I removed all the continuation characters and this did not solve the problem, or allow the code to execute, but I don't recall what the error message which resulted from that attempt was.

Is there a maximum number of columns one can import into Excel using VBA? Silly question, right? It can't be as low as 150. Must be something else. Excel 2003.


hello,

is it possible to filter only specific columns in excel 2003?

for example I have autofilter on all of my columns A-Z.

what if i just want to have a drop down filter for A-D and then G-K and then N-P, etc. etc.

Any help is much appreciated. From the gurus I've talked to here at work it can't be done. I can only select a few columns in sequence and have the filters there or it breaks the merge apparently of columns. So it's either all the columns with the autofilter to the left/right only but not a few here and then a few over there if that make any sense. Thanks!!


I have a database that I want to run queries against to create a Cube within
Excel 2003. I've tested it out on a small amount of data and it works great.
My question is, what is the maximum size in terms of physical .cub file
size, number of records, number of dimensions, etc. that Excel 2003 has. I'm
trying to figure out if this solution will work for my client or if I need to
get them a full blown analysis services install.



Why should MS Excel daily user switch from Excel 2003 to 2007 (or 2010)?
I'm considering to change from XP to W7 64 bit.

I've been a keen friend of Excel since version 95 and Quattro Pro prior to it. I have created some business applications and databases with some macros for daily personal usage. I have bought DigiDB lisence for Excel 2003.
I keep Excel 2003 running 24x7 on my workstation. Same to Outlook 2003 from Office packet but normally I don't use any other Office components..
I run XP Pro as it's still a flawless environment but likey XP is coming to end due to decreasing support from MS and advanced HDD formatting standard.
So there is no other way but sooner or later to switch to Windows 7 and 64 bit to achieve better photo handling capabilities.
But what about MS Office 2003?
I have searched the web but couldn't find any replies to the question why should I one from Office 2003 Pro to Office 2007 or 2010. More rows and more columns isn't a reason to me.
Any suggestions, should one go to Win 7 64 bit and still keep Office 2003 32 bit?


Hi all,

I am working with Excel 2003 which has a limit of 256 columns. I often import text files into excel using a very simple macro. I specify the text file's name and location in a cell and then run the macro - it opens the text file, copies the data and pastes it into the worksheet, then delimiting the columns using the semi-colons that seperated the data in the original text file.

However, I now have a text file that would convert into excel as around 1,000 columns and about 20 rows. This obviously causes a problem since my limit is 256 columns in Excel 2003.

Is there any way that Excel can transpose my data when it brings it into the spreadsheet from the text file so that I end up with 20 columns and 1,000 rows? Ideally I'd do this in VBA and add the code onto my existing little macro.

Any help greatly appreciated.
Jon


I am doing a mail merge file in Word 2003 that imports from an Excel spreadsheet. The issue I am having is that it is not importing the data in certain columns from the spreadsheet into the Word document. When I bring up the Mail Merge Recipients List in word, and scroll through the data, there are certain fields that are blank and should have data, and since it is only certain columns where the data is not being imported, I'm assuming the issue lies somewhere within my Excel spreadsheet or possibly what I'm using as the column header label for these columns. The data in these columns is numbers, and I've tried reformatting the cells to different types (general, number, accounting) with no success. Any thoughts or suggestions on what is causing this from the Excel gurus out there is appreciated!!


Using Excel 2003

I have a very large spreadsheet, only 2 columns are left without any information (Column IU & Column IV).

The file has subtotals and Groups have been applied to the columns. When I try to minimize a group I am receiving and error box that states :

Cannot shift objects off of sheet. Is there a limit to the number of Groups? I have confirmed that there are still 2 blank columns.


Thanks for any help.


Does anyone know if there are a maximum number of tabs for one work book in 2003 like there are a mximum number of columns on one sheet? Also I have heard that if there are too many sheets then it can damage the integrity of the file as a whole. Is there any support to this?

Thanks for your help!


I have created a large spreadsheet about 3mb in Excel 2007.

When I save this for use on a 2003 machine, it says that there is data beyond the maximum columns and rows....

If I goto find error, it refers to a cell that is well within the range permitted. I have gone to each sheet and selected goto (F5), special and selected last cell. I can't find anything anywhere near the limit.

What is strange is thta the warning does not appear when I save the file with the sheet in question selected. Instead it only comes up if I am on a different sheet.

I have looked on the net for a solution and some had posts stating that the cell Excel thinks is outside the 2003 range refers to merged cells or has merged dependents, but my spreadsheet does not have this.

It is a major problem because some of our clients use 2003 and when they open it, they get a warning that it is not compataible and data will belost which is not the case.

Can anyone help?




I have two columns. First column contains a sorted list of years and the second column contains values for that year.
E.G.
Column B Column C
2001 27-330
2002 27-330
2003 27-330
2003 27-230
2003 27-230
2003 27-330
2003 27-280
2003 27-250
2003 27-230
2003 27-230
2003 27-230
2003 27-230
2003 27-230

I would like to count the number of occurrences in column C based on Column B and print it to an array format.
Been able to set up the header and row names, but now need to fill in the array.

Please help!!

Master Workbook Rev 9.xlsm

Heres a good one!

Access 2003 / Excel 2003

I have an access database with a table which is the source for a new database query in excel. The access table has 29 columns and the Excel query in the query view has the same 29 columns. Two of the columns always have NULL data (i.e. they are empty) - this is preserve CSV file layouts (I know.. I know..)

When I return the query results to the spreadsheet, the two columns have been dropped and I only have 27 columns. I can't find anything about this on the web, has anyone else experienced anything similar?

Obiron


Can anyone tell me the maximum records(rows) and variables (columns) allowed in Excel 2003, version.
Maybe this is repeat but i tried the search and came up with nothing.
Thanks


How do I restrict what I see on my screen (and specifically, limit the scroll
feature) to the rows and columns I'm actually using in an Excel 2003 Pro
spreadsheet?




The way I understand it, the maximum number of rows for Excel 2003 is around 65,000. Is there a way around this? I am working on generating a report that needs close to 250,000 rows. Is there maybe a way that I can treat two columns as one so that Excel think they are the same column? This way when the column is full (max. # rows exceeded), the next column will start to fill up? Any ideas?


I replied to this thread ( http://www.excelforum.com/excel-gene...to-column.html ) earlier and my post was removed so I'm guessing that should have started a new thread. Humble apologies for that.

I've got a problem where I'm trying to set out a customer database. I've got about 40 columns and need to have this information printed off on one sheet of paper. So I need the column headers and then each line of information to run in two columns.
If only excel had enough columns (256 limit on 2003 version) and you could sort horiziontally as well as vertically then I would just layout the worksheet the other way, but here we are.

I've been messing with the code that was kindly posted on the other thread but to be honest I haven't got a clue what I'm doing and I know my pc is just laughing at me.
I've attached a sample spreadsheet (excel 2003) to show you what I'm trying to do, with the details to be entered into the MAIN worksheet, and to be printed off from the PRINT worksheet.
If anyone could briefly explain (or point me in the right direction) of how to set this up with the macro I'd be really grateful. My excel knowledge is fairly limited, so be gentle please.
Thanks,
Gareth


Hi all,

On one computer I run MS Excel 2003 and Windows XP Professional.
On a new, recently bought computer I run Quattro Pro X3 and Windows Vista home premium.

So I've copied some sheets to the new computer and opened them with Quattro Pro.
Sometimes it returned the message "Quattro Pro loader discovered a problem" or something like this.
Sometimes it actually did open the file.

Since today Quattro Pro gives a runtime error immediately when started up, and shuts down.

Does this have anything to do with opening sheets from another version?


Hi, I need to limit the maximum amount of characters in one of my columns to 2,000 characters. The only thing I have found so far was Quote:

select all the cells that you want to limit the length to 30 chars. Go to Data|Validation, then in the "About" box select "Text Length". You can then choose "Less Than" etc. to set you limit.

However, I don't get this option in Excel 2003. I select Data>Validation then under settings I choose Text Length and Less Than Or Equal To but then under the Maximum field I don't know what to put since it only allows a formula and not a number like 2000.

Thanks.


Someone has sent me some Quattro Pro 7.0 files that I need to open up. When
I had Excel 2000 before, it was as simple as downloading a converter and the
files opened up in Excel. However, for Excel 2003, I cannot find a converter
anywhere on the web site. Can someone point me to a converter or how I can
convert into Excel 2003 from Quattro. I have already tried the "Office
Conversion Pack" that the downloads site seems to direct me to.

Thanks,
Clark



I'm using Excel 2007 to create a worksheet for use in a 2003 environment. The spreadsheet works perfectly in Excel 2007, but gives me a #NAME? error in Excel 2003.

I have three columns with times and want to find the difference between the various times for task tracking.

Each of the three "input" columns are formatted as: 4/26/2010 8:18:00 AM
E = time request received (e.g., 4/26/2010 8:18:00 AM)
F = time request started (e.g., 4/26/2010 8:32:00 AM)
G = time request completed (e.g., 4/26/2010 11:54:00 AM)
H = # of documents completed for the task (number, e.g., 4)

I have three calculation columns that calculate the difference between the columns that return the number of days as a decimal. I'm using work days since the tasks can span a weekend. The working start time and working end time are contained in J2 and J3, respectively.

I = Pre-Work (D) Receipt to Start =IF(G7>0, ((NETWORKDAYS(E7,F7,)-1)*(J$3-J$2)+MOD(F7,1)-MOD(E7,1)), "")

J = Working Time (D) Start to Complete =IF(G7>0, ((NETWORKDAYS(F7,G7)-1)*(J$3-J$2)+MOD(G7,1)-MOD(F7,1))/(IF(H7>1,H7,1)), "")

(Note: the IF statement is to divide the working time by the number of documents to get an average time per document)

K = Turn Around Time (D) Receipt to Complete =IF(I7="", "", J7+I7)

The problem is when the value is 0 or close to 0, Excel 2003 returns a #NAME? error. This error does not appear in 2007.

How can I modify the formulas in I and J to display correctly in 2003?


I want to make a programming chart for 365 days in Excel 2007. I can only create 256 columns, yet the help files say that maximum number of column is 16,000 odd. Guess it must be me but what am I doing wrong??

Any help most appreciated.


Hi

I have a csv file with about 7000 rows, if i were to transfer these to columns would i hit a limit, in other words can excel support data in 7000 columns?
It is excel 2003

Thanks