Super User Stack Exchange
Super User Stack Exchange

Questions tagged [microsoft-excel-2003]

The 2003 version of Microsoft's spreadsheet application.

Microsoft's lifecycle support has ended for excel 2003 source.

Support ended in 2014. If you're having issues with excel 2003, please keep in mind that this version has many limitations compared to later versions and there may not be a workable solution.

277 questions
43
votes
2 answers

Merge two excel files using a common column

I have two excel sheets. I have to merge the two such that the values in one match with the other. For eg. The first excel, the 2nd excel 1 t 1 tes1 2 5 3 tes3 3 t 4 tes4 4 g Notice that…
Indy
  • 533
8
votes
1 answer

Why is the maximum row height in Excel 546px?

The maximum height of a single row in Excel 2003 is 546 pixels, or 409.5 points: http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP005199291.aspx I'm curious as to why this number was chosen. The other limitations…
Snorfalorpagus
  • 223
4
votes
2 answers

Excel 2003 - how do I dock\fixate a row\column?

how do I create a docked row\column so that when I scroll down\right, I can still see that row?
Leon
  • 43
4
votes
1 answer

Excel "This workbook contains links to other data sources"

I am getting this pop-up in Excel 2003, "This workbook contains links to other data sources", with the options to "Update" or "Don't Update". The workbook is using VLOOKUP to get information from another workbook. Is there any way to disable this in…
Carl
  • 348
4
votes
2 answers

Excel: how to add cells to named range

I have a named range for 3 cells in excel 2003 I need to insert 1 more cell into this named range how do I achieve this in excel 2003
balalakshmi
  • 845
3
votes
2 answers

How to prevent users to change cells but allow VBA to change them

I'm using a Excel spreadsheet to record staff resource. In column B, there is a value of "Enter your name", which instructs the user where to start entering their information. Then, when the user enters their details in this row, the next row is…
IRHM
  • 195
3
votes
2 answers

Excel cutting out down over 1024 characters

I am using Excel 2003 to save a large file as a CSV. But when saving cells that contain over 1024 characters, it cuts out the characters beyond 1024. Per a previous question, I am using this official macro to save:…
Zeno
  • 201
2
votes
5 answers

Stop MS Excel 2003 closing all open workbooks

I have noticed that when I have multiple workbooks open with MS Excel and I close one, excel will attempt to close them all. This is extremely frustrating and has resulted in me losing work on many occasions. Is there any way that I can stop Excel…
JT.WK
  • 1,961
2
votes
3 answers

De-pivot excel spreadsheet

Using Excel 2003 Can i... Given a spreadsheet of this layout with Permissions being Read = R , Write = W and No permission= X Users Perm1 Perm2 Perm3 ... ..... PermX User1 R W X ... ..... R User2 X …
ggonsalv
  • 351
2
votes
1 answer

How to prevent Excel from corrupting certain data when copy-pasting from Word to Excel?

I need to copy & paste a large table (54 pages of data) from Word to Excel. Works great except when some of the cells contain ranges (1-10, etc), Excel insists on interpreting them as dates and promptly CORRUPTS the data (you CANNOT obtain the…
Alex R
  • 1,844
2
votes
1 answer

Hyperlink refers to the new location of the referenced cell

I'm using Excel 2003. I have a hyperlink in cell E4 in worksheet406R to cell E4 in worksheet104S. When I move E4 in worksheet104S to another location (E16) or sort the data in this worksheet, the cell E4 in worksheet406R still displays the content…
Hany
  • 229
1
vote
1 answer

Having more spreadsheets displayed in the recent opened list in Excel 2003

I'm currently using Excel 2003. The list of recently opened spreadsheets accessed through the File menu contains the last four opened and edited spreadsheets. Is it possible to change the number of spreadsheets displayed, so that it can display for…
Loic
  • 535
1
vote
1 answer

How to create an Excel SUMIF formula that can compare different date formats

For my source data I have a column of dates in the dd/mm/dddd format, and a column of values next to it. eg 03/02/2014 5 17/02/2014 4 03/03/2014 5 17/03/2014 4 On a summary sheet I have a row of cells with dates in the mmm-yy format.…
Dave
  • 147
1
vote
2 answers

How to create a two column pick list in Excel

I want to be able to have a pick list with two columns setup in a worksheet and pick from that list in another worksheet to populate two columns. Pick List Sheet would look like this A Item 1 Item 2 B Johnson 22 C Jones …
Eric Langley
  • 11
1
vote
1 answer

Unable to add, create, or remove drop downs on an Excel 2003 spreadsheet

In Excel 2003 the Validation option under Tools is grayed out for a specific workbook. The sheet is not locked or protected, but it is shared. Even the author of the sheet has the Validation grayed out. I can change the drop down choices, though.…
Dan
  • 21
1
2 3 4