The 2003 version of Microsoft's spreadsheet application.

**2**

votes

**3**answers

3k views

### Excel Pivot Table Date Range as Columns

I have the following data which I wish to pivot:
Student JoinDate ReleaseDate
John 01/05/2011 05/05/2011
James 02/05/2011 04/05/2011
I would like to create a pivot table which ...

**1**

vote

**3**answers

829 views

### How do I use a linked cell in Excel in a formula?

I am trying to create a formula using a cell that holds data linked from another tab in the same spreadsheet. When the source cell is blank, the linked cell shows "0". Is there a way to have the ...

**2**

votes

**1**answer

941 views

### Random Excel bug when referencing a different sheet

I am getting a very strange error anytime I try to use a formula pointing to a cell in a different sheet from the active one (even as simple as "=Sheet2!A1"). This started happening all of a sudden, ...

**1**

vote

**1**answer

2k views

### Drag-and-drop a new series onto an Excel chart

In Excel 2003, I can select a new data series and drag it onto an existing chart to add it to that chart. In Excel 2007 I can't. Does anyone know if this functionality was removed or if it is ...

**2**

votes

**1**answer

167 views

### Make dates appear on the X-axis and the color category appear on the Y-axis

There is probably a fairly straight forward answer out there but I can not seem to find a solution online.
I have a table marked up like this (column names are in bold)
audit date | blindness
...

**0**

votes

**1**answer

674 views

### VBA xlColumnDataType in Excel 2003

When importing a txt file into excel, I need to specify data types for the columns.
I'm currently using Excel 2003 (upgrade to 2010 is for later in the summer).
I have been able to find enumerations ...

**0**

votes

**1**answer

2k views

### In Excel VBA Macro does ActiveWindow.Scroll change ActiveCell at all

I'm cleaning up and extending some excel VBA macros (written and currently running in Excel 2003), and I have a question about how far I can go in cleaning up without modifying the output.
There are ...

**3**

votes

**1**answer

2k views

### Excel 2003: open spreadsheet and run macro from command line

The need: run a macro within an excel 2003 file every week, automatically, than save the file.
The approach: add an action to task manager for every week, calling the file with command line ...

**0**

votes

**1**answer

2k views

### Excel Shapes Disappear When I Move or Copy a Sheet

I have a sheet in an Excel 2003 (xls) workbook that has numerous textbox shapes in.
If I move the sheet or copy it to another workbook, the textboxes don't move with the sheet. Everything else ...

**1**

vote

**2**answers

1k views

### Data validation - populating a drop down menu using a defined name

I am using data validation to create a drop down list on a worksheet. What I'd like to be able to do is set up a list of values as a defined name (Insert > Name > Define...) and then enter that ...

**0**

votes

**3**answers

633 views

### Open Excel 2003 XML files (XMLSS) in Excel 2000

I need to open Excel 2003 XML files (not Open XML from 2007) in Excel 2000. Is there any plugin that would allow me to do this?
Edit: the name of the format is called XMLSS - XML Spreadsheet

**0**

votes

**3**answers

4k views

### Move markers of line chart/ Format legend

I have a combination chart with a bar chart and 2 line graphs on secondary axis. have to exactly match the formatting in the screenshot attached ( I do not have the actual excel file. just have a ...

**3**

votes

**1**answer

4k views

### Excel (.xls) files not opening in Excel when launched from Explorer

I appear to have done something to Excel (2003) whereby whenever I double-click on an Excel file (.xls) in Windows Explorer, Excel launches OK, but the corresponding workbook doesn't open, and I'm ...

**3**

votes

**3**answers

5k views

### 255 Character limit on VLOOKUP

Using excel 2003, the formula:
=VLOOKUP(D1 ,A1:B135, 2)
fails if the length of D1 exceeds 255 characters (i.e. the list has some text longer then 255 characters, D1 has the same text value, and ...

**2**

votes

**1**answer

772 views

### How to filter out data between two columns?

I have data in my excel sheet in the below format
A B
1 2
2 3
3 5
4 8
5
6
7
8
9
i.e colA has values 1 through 9 and colB has 2,3,5,8. Now what I need in ...

**0**

votes

**1**answer

90 views

### need to find how subtract in excel

I need to find the time difference.
I have a exacle sheet which I have made cells format as number before going to past the data in that exacel.
I have starttime in A column end time in B column ...

**2**

votes

**5**answers

1k views

### Excel not properly recalculating values

I have an Excel sheet with values in it (this sheet is generated by a custom perl script, but I don't think that's where the problem lies). In it, I have a formula:
...

**2**

votes

**1**answer

192 views

### Returning Shapes to Default in Excel

I have around 70 shapes in a planning document i use for work, everything is fine but i am trying to add a new feature. These shapes are changed using edit points each week to show up on a map, but ...

**0**

votes

**3**answers

2k views

### Excel 2003 lag under Windows 7

I'm running Excel 2003 under Windows 7 64-bit. Even on a blank spreadsheet, Excel 2003 will lag or freeze up every 10 seconds or so and every time I insert a value in the spreadsheet. I have ...

**3**

votes

**2**answers

3k views

### 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?

**0**

votes

**1**answer

878 views

### Excel file with macros saved in 2007 crashes when opened in 2003

My team keeps a large Excel file on a SharePoint server. Recently I've edited this file with Excel 2007 and saved it. Afterwards, everyone who opened the file with Excel 2003 and chose to "Enable ...

**1**

vote

**1**answer

9k views

### Excel: Calculating working hours between two dates

Summary:
I know that the function NETWORKDAYS can be used to find the number of business days (=excluding weekends and holidays) between two dates. But what if I want to know the number of business ...

**0**

votes

**1**answer

833 views

### Select graph data to display using checkbox

I dont know if this can be done in excel or not. I tried to look around but could not find anything. Here is a simple example - There is a simple column graph for sales, expenditure and profits. There ...

**3**

votes

**2**answers

14k views

### Fill an area between two lines in a chart in Excel

There are a lot of hacks to fill the area between two lines in a chart; however, I want one that works seamlessly between 2003/2007 and mac 2011. Preferably, something that is not a hack.

**2**

votes

**1**answer

1k views

### In Excel, how to group data by date, and then do operations on the data?

I have Excel 2003. My data is like this:
01/10/2010 0.99
02/10/2010 1.49
02/10/2010 0.99
02/10/2010 0.99
02/10/2010 0.99
03/10/2010 1.49
03/10/2010 1.49
03/10/2010 0.99
etc. In fact it is a list of ...

**2**

votes

**1**answer

1k views

### Macro name being changed in Excel

I am creating VBA macros in my Excel spreadsheet. I notice that from time to time (after saving the spreadsheet and reopening it, usually) one or more of the macro names is being changed from ...

**12**

votes

**1**answer

35k views

### How do I put logical operators in an Excel =IF Formula?

I'm trying to enter a formula to display text according to an IF condition. The best I can manage is something like...
=IF(myval>=minval & myval <= maxval, "OK", "Not OK")
But this ...

**1**

vote

**2**answers

9k views

### Color drop down in Excel cell (with no text)? e.g. bgcolor = Red-Green-Amber-unknown

I have an Excel sheet that I'm using to keep track of the status of certain things.
I want to have a column which consists of cells containing a repeated drop down that allows you to select (as ...

**1**

vote

**2**answers

8k views

### Excel - Chart that sums the values in multiple rows for each series

Suppose I have a spread sheet that looks something like this...
Now, I'd like to create a column chart that has 3 series, one for each country. Then, I want series for each category, but I want to ...

**2**

votes

**5**answers

355 views

### Converting date format in formulas in Excel

what is the formula which would enable me to calculate the difference between 2 dates and 2 times? Example: In the same cell, I have 01 January 2005 07:30 and in a second cell i would have 06 January ...

**1**

vote

**1**answer

578 views

**0**

votes

**0**answers

454 views

### Microsoft Query Wizard specify Column Filter that is greater than or equal to 30 days from today

I'd like to use Microsoft Query Wizard specify Column Filter that is greater than or equal to 30 days from today. Is there reserved name that I can use, like TODAY-30 under the filter criteria?

**1**

vote

**3**answers

3k views

### How to count the number of occurrences of all cell values in a specified range

I have an Excel worksheet with one column of cells with any string values, so, like this: A, B, A, D, C, C, A, A. What I am wanting to do is to count how many times each value occurs and print that ...

**2**

votes

**2**answers

3k views

### Refresh values in Excel 2003

I have an excel file with three worksheets(ws), the first two have raw data and the third one contains formula to compare the data in other two ws. For example, here is an example of my comparison ...

**0**

votes

**0**answers

249 views

### Remove password of excel sheet [duplicate]

Possible Duplicate:
Recover Sheet Protection Password for and Excel Sheet
How to remove/recover the password for the excel sheet online for free?

**2**

votes

**3**answers

12k views

### Excel 2003 upgrading to Excel 2010, will it break our models?

My office is upgrading from Excel 2003 to Excel 2010 and we have a lot of tools in Excel 2003 (complex custom formulas, named ranges, VBA, pivots... almost every feature of excel can be found in at ...

**0**

votes

**1**answer

422 views

### how do I make a sum total to always show up on below the last populated cell in a column

I am making an invoice template that pulls data from an external source. The amount of customer order line rows are variable, so I would like the sum total figure to sum all populated cells in ...

**2**

votes

**2**answers

667 views

### Using excel sheet as a function

I wonder how I can use an excel sheet as a function.
Let's say I have a complex calculation in Sheet1 with one parameter I would like to iterate over a range like [1 to 400] in a second sheet to ...

**1**

vote

**1**answer

466 views

### Excel 2003 doesn't undo after saving

Every time I save changes on Excel, it doesn't allow me to undo the changes I did before saving. Is that the normal behaviour of Excel 2003 or I have some weird seetting done?

**1**

vote

**1**answer

579 views

### Excel 2003 Insert Function Wizard Animation Lag/Delay/Stuttering

I'm using MS Excel 2003 on Windows 7. I get animation lag anytime I open or close the Insert Function Wizard. I'm running on an ATI Radeon HD 4870 with the latest drivers (Catalyst 10.8 -- ...

**0**

votes

**1**answer

857 views

### Using Excel Chart Elements in Powerpoint

How do I make Excel chart pie slices available for custom animation along with other elements in a PowerPoint slide?

**5**

votes

**3**answers

2k views

### How can I change the z-order of data series on the secondary y-axis relative to those on the primary y-axis in Excel 2003?

In Excel 2003, it's possible to change the z-order (i.e. what plots on top) of data series plotted on an axis by right-clicking a point of one of the series, choosing "Format Data Series", and then ...

**0**

votes

**5**answers

2k views

### Why do 2 excel (2003) files that are exactly the same have different file size?

I have two excel files that are exactly the same (in terms of the content of the file) but differ by quite a margin on file size. One file is 37.5 KB while the other is 56 KB. The only difference I ...

**1**

vote

**1**answer

3k views

### Excel file with PivotTables - reduce size

I have an Excel file with several tabs, one of which has two PivotTables. The data source for the first table is a specific range of rows (not an entire column) and the second table is based on the ...

**1**

vote

**1**answer

154 views

### Real time Export of excel 2003 fields to MS word 2003 fields

I am a practicing radiologist. We enter patient information such as Name, date of birth, number (patient ID), referring physician's name, and date of the study at the front desk in MS Excel 2003. Is ...

**1**

vote

**2**answers

2k views

### Format Change Event for Excel VBA

I'm trying to prevent people from modifying (most) of my spreadsheet while still alowing them to use the sort function of the AutoFilter. What I've done so far is used the Worksheet_Change event and ...

**4**

votes

**1**answer

13k views

### How to change font color in Excel based on cell value?

How do you change the font color of a column of cells based on their entered value? I've got a column with the heading at row 1 and the values starting at row 2 going on down. I want to change font ...

**0**

votes

**2**answers

4k views

### How to have sequential numbers keep writing themselves?

At work, we use Microsoft Office 2003, and we have to write many numbers that are sequential, e.g. 2590, 2591, 2592, etc. These numbers are either in Excel or in a Word table.
How can I ...

**1**

vote

**1**answer

994 views

### 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 ...

**2**

votes

**1**answer

629 views

### Divide pivot table data by an arbitrary column in another table

I have this data from a pivot table:
Countries P1 P2 Total
Country 1 10 69
Country 2 36 2 92
Country 3 21 24 100
Country 4 22 77
Country 5 13 79
Country 6 12 1 ...