Email:      Pass:    Pass?
Close Window   
TE
Free Excel Tips in Your Email!
Join Over 20,000 Happy Subscribers!
E-mail:
Subscribe for Free Excel tips & more!
E-mail:


Advertisements


Free Excel Forum

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 Video Tutorials

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?


Is there a maximum amount of hidden columns within Excel? I have double-checked protection, and I have enough columns total for the action I'm attempting to do. I am using Excel 2003, and working on a rather large spreadsheet for a forecast. The basics of it is that I have macro's within buttons set-up so that users can hide columns and just view certain columns for approximately 30 columns per week and 5 weeks.
And I can run the hide macro's for up to 4 weeks at a time, but when attempting to hide the 5th week it gives me a "Run time error 1004" Unable to set the Hidden property of the Range class.

Have I perhaps just reached a maximum of hidden columns?

Thank you,


I'm thinking about upgrading to excel 2007 as I have a certain analysis that requires more than 256 columns. My questions is if someone else opens my spreadsheet in excel 2003, what will happen if I had data in more than 256 columns when they open it in their 2003 version. Thanks guys


Greetings,

I am running: Microsoft Office Excel 2003 (11.8316.8221) SP3

My question is this:

Is there a way for me to increase the maximum amount of data that an Excel spreadsheet "cell comment" box will hold?

Whenever I am working inside a .XLS spreadsheet, I frequently make use
of the "cell comment" feature which allows me to make special notes or comments on selected spreadsheet cells. The problem is that sometimes when I am copying and pasting large amounts of data into the cell comments box that holds the comment, Excel seems to allow me to paste only so much data into the cell comment box and then it will not let me add any more comments/data. This seems to indicate that I have reached the maximum amount of data that the cell comment box is allowed to hold.

So again, is there a way for me to increase the maximum amount of data that an Excel spreadsheet "cell comment" box will hold?

All sincere/thoughtful replies are solicited and appreciated!

Regards,

Rob Sandifer


Hi everyone - huge thanks in advance to anyone that can offer some assistance with this problem.

I have a 6x5 matrix with a series of data in it. It is as simple as this:

Row 13: 0 1 2 3 4
Row 14: 0 1 2 3 4

and this is repeated over for 6 rows. The figures in each cell can increase or decrease (dependant upon another multiplier elsewhere).

I need a formula to work out a % total for this data - but I really need each row to only contribute an equal amount (16.6r or 100/6)and when it reaches that maximum for it to contribute no more. (i.e - if rows 14, 15, 16, 17 and 18 are all 0 - I want the maximum that can come from Row 13 to be 16.7%)

If I simply SUM this data - I could potentially end up with 1000% total (if the figures increase then so will my % total) which would defeat the point.

I hope this makes some sense to someone and you'll be able to help. Please question me if it is not clear.

(Doubt it matters but I'm using Excel 2003)


My apologies for the cut and paste. I saw that someone posted this a year ago but i did not see a response. I am having the exact same issue,

"I am trying to open Quattro Pro 7.0 files (.wb3) in Excel 2003. It says in
their documents about supported file formats that this file format is
supported for opening in Excel 2003, with a converter installed. I've
installed the entire Excel 2003 software, along with all service packs and
the Office 2003 Conversion Pack. I am still unable to open Quattro Pro 7.0
files in Excel 2003. There are downloadable converters for Excel 2000 and
97, and those work fine for those version. But, there is nothing for Excel
2003 and information is scarce."

Thanks!


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.


Hello,

i have a problem sorting my data, and i think it can be done quite easily if one is good at excel and IF formulas. Here is a sample of my dataset:

01.02.2003... 2 ... -
01.02.2003... - ... 1
01.02.2003... - ... 2
01.03.2003... 2 ... -
01.03.2003... 2 ... -
01.03.2003... 2 ... -
01.03.2003... 1 ... -
01.04.2003... 3 ... -
01.04.2003... - ... 5
01.04.2003... - ... 2

What i wish to do is sum up for each date, column 2 - colum 3, giving me a summation of total column2 - column3 for each day of the year. i have several years worth of observations, so this has to be done automatically, in excel 2007.
There are not the same number of observations each day.

a wanted result would then be:
date ----------- c2 -- c3 - Sum
01.02.2003 ... 2... -
01.02.2003 ...- ...1
01.02.2003... -... 2 ... -1
01.03.2003... 2... -
01.03.2003... 2... -
01.03.2003... 2... -
01.03.2003... 1... - ... 7
01.04.2003 ... 3 ... -
01.04.2003 ... - .... 5
01.04.2003 ... - ... 2 ... -4

i know i was quite unclear, so please let me know if you dont understand what i mean.

thanks for any help you can give me,

best regards

Finn


Hi everyone. I've got a dilemma and I need some help if you dont mind. I have a spreadsheet like this:

Sheet1

* A B C D E F G H I J 1 Symbol Date Price Volume * * SYMBOL DATE PRICE VOLUME 2 CAA 01/02/2003 95.20 10 * * * * * * 3 CAB 01/02/2003 96.00 7 * * * * * * 4 CAC 01/02/2003 94.21 5 * * * * * * 5 CAD 01/02/2003 98.83 2 * * * * * * 6 CAA 01/03/2003 96.53 48 * * * * * * 7 CAB 01/03/2003 93.24 15 * * * * * * 8 CAC 01/03/2003 97.00 32 * * * * * * 9 CAD 01/04/2003 91.11 153 * * * * * * 10 CAB 01/04/2003 88.06 32 * * * * * * 11 CAC 01/04/2003 85.00 56 * * * * * * 12 CAA 01/07/2003 75.00 25 * * * * * * 13 CAB 01/07/2003 76.64 25 * * * * * * 14 CAA 01/08/2003 91.00 15 * * * * * *

Excel tables to the web >> Excel Jeanie HTML 4


Columns A to D are sorted by date.

I would like to fill columns G to J with the info described by the headings in this way: the info must be for each date but with the highest volume.

So in this case, the dates that must appear in column H are :

01/02/2003
01/03/2003
01/04/2003
01/07/2003
01/08/2003

because they are the dates that exist in column B.

For rest of the info that must accompany these dates are those in that row where the volume is highest for that date. So for the date 01/02/2003, the highest Volume in column D for that date is 10, and so what should appear in columns G to J for that date is:

Sheet1

* G H I J 1 SYMBOL DATE PRICE VOLUME 2 CAA 01/02/2003 95.20 10 3 * * * * 4 * * * * 5 * * * * 6 * * * * 7 * * * * 8 * * * * 9 * * * * 10 * * * * 11 * * * * 12 * * * * 13 * * * * 14 * * * *

Excel tables to the web >> Excel Jeanie HTML 4

So on 01/02/2003, symbol CAA has the highest volume for that day of 10 with a price of 95.20.

For those dates wherein one or more symbols have equal volume, what should be used is that symbol which has the earliest 3rd letter. So for example, 01/07/2003 has two symbols (CAA and CAB) that have the same volume of 25. Since the thirld letter of CAA is A while the third letter of CBB is B, we use CAA's info. So, for 01/07/2003, it must be:

Sheet1

* G H I J 5 CAA 01/07/2003 75.00 25

Excel tables to the web >> Excel Jeanie HTML 4

So the result all in all must be like this:

Sheet1

* G H I J 1 SYMBOL DATE PRICE VOLUME 2 CAA 01/02/2003 95.20 10 3 CAA 01/03/2003 96.53 48 4 CAD 01/04/2003 91.11 153 5 CAA 01/07/2003 75.00 25 6 CAA 01/08/2003 91.00 15 7 * * * * 8 * * * * 9 * * * * 10 * * * * 11 * * * * 12 * * * * 13 * * * * 14 * * * *

Excel tables to the web >> Excel Jeanie HTML 4

Whew! I hope that didn't sound too confusing or daunting. I've just got a ton of data and doing it manually would drive me crazy. If there's a procedure or macro or anything that could do this which you guys could suggest, it be would a big big help. Thanks!


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,

Since i started VBA some days ago, this board has helped me a lot in solving problems regarding it.
Thanks to u all for such a nice board.

As i hven't studied excel and VBA much but have to work on it instantly, so i get a lot problems.

this time my prob. is like:-
I have two columns A,B
I have to check values in column A and sum up values in Col. B having same values in A. Then replace all those rows with a single row having this Common value in A col and sum of B in B col.(in VBA)
eg.
A col. B Col.
01/2003 12
01/2003 04
02/2003 09
03/2003 10
03/2003 05

now i want it like this

01/2003 16
02/2003 09
03/2003 15

Can u please give code of doing this with VBA.

Thanks a lot again
Bye
Saurabh
02/2003 09


Hello,

i have a problem sorting my data, and i think it can be done quite easily if one is good at excel and IF formulas. Here is a sample of my dataset:

01.02.2003... 2 ... -
01.02.2003... - ... 1
01.02.2003... - ... 2
01.03.2003... 2 ... -
01.03.2003... 2 ... -
01.03.2003... 2 ... -
01.03.2003... 1 ... -
01.04.2003... 3 ... -
01.04.2003... - ... 5
01.04.2003... - ... 2

What i wish to do is sum up for each date, column 2 - colum 3, giving me a summation of total column2 - column3 for each day of the year. i have several years worth of observations, so this has to be done automatically, in excel 2007.
There are not the same number of observations each day.

a wanted result would then be:
date ----------- c2 -- c3 - Sum
01.02.2003 ... 2... -
01.02.2003 ...- ...1
01.02.2003... -... 2 ... -1
01.03.2003... 2... -
01.03.2003... 2... -
01.03.2003... 2... -
01.03.2003... 1... - ... 7
01.04.2003 ... 3 ... -
01.04.2003 ... - .... 5
01.04.2003 ... - ... 2 ... -4

i know i was quite unclear, so please let me know if you dont understand what i mean.

thanks for any help you can give me,

best regards

Finn


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.



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


Hi

I have a worksheet in Excel 2007 that has 400 columns on it - l want to save it so that it can be opened on Excel 2003 but l get a message saying anything over column IV will be lost.

Is there a way to make Excel2003 have more columns? Or is there a better way of doing it?

The reason the sheet is 400 columns wide is that it is a year planner so needs 1 column per day

Thanks in advance


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?


Excel 2003, part of Office Professional 2003
Windows XP Pro SP2

Spreadsheet currently has text columns & data [ US $ ] columns.
Columns A, B, C have information about the contact
Data is in columns D, E, F
Column H notes the group to which the the contact belongs
I would like:
1. column G to equal a sum of columns D, E, F

2. the final row of columns D, E, F, G to equal the sum of the previous
rows of the corresponding columns. When I add another row, I would like the
new total to automatically appear. i.e., when I have information in rows 1 -
20, cell D21 will provide a sum of D1 - D20. When I add information to row
21; D22 will automatically sum cells D1 - D22.

3. the contacts of each group to be sent to a separate file / document /
spreadsheet, so that a mailing list can be created, by group.

Thanks for your help.

WC



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?


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