The 2003 version of Microsoft's spreadsheet application.

**2**

votes

**1**answer

183 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

1k 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 ...

**1**

vote

**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

744 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

7k 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

685 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

7k 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

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

**11**

votes

**1**answer

25k 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

7k 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

5k 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

310 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

502 views

**0**

votes

**0**answers

423 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

2k 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

247 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

410 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

494 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

411 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

554 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

741 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

1k 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

2k 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 ...

**2**

votes

**1**answer

539 views

### Conversion Pdf 2 Excel

Hello to everyone and thank you in advance to all the superusers that will help me.
I need to find a freeware (not trial) able to convert a pdf document on a excel sheet. Could the superusers ...

**1**

vote

**1**answer

149 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

11k 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

3k 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

866 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

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

**2**

votes

**1**answer

10k views

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

**1**

vote

**2**answers

800 views

### Remove Excel 2003 macros easily

I am using Excel 2003 and I have some workbooks that I have to send several days a week to some recipients.
These workbooks have macros in it and I don't want the people receiving the file to be able ...

**3**

votes

**3**answers

4k views

### How do I exit Excel full screen after switching desktops using MSVDM

When I switch desktops with MSVDM (Microsoft Virtual Desktop Manager) Excel goes into some kind of full screen mode, where no tool bars or menus are visible in the Excel window. Then I can not find ...

**1**

vote

**7**answers

3k views

### Extend the number of rows in Excel 2003 beyond the allowable 65k

I'm stuck with excel 2003 at the office, I was wondering if there is a way to extend the number of rows to at least a million or two.

**1**

vote

**2**answers

206 views

### converting custom number h:mm into time

I have time values entered in Excel as a custom number h:mm. I would like to convert these to a format (still displayed as h:mm) which will allow me to perform calculations using the data. Any ideas?

**0**

votes

**1**answer

190 views

### Moved files only opening as 'read-only' in Excel

I moved a large directory of Excel files to another machine. When I sign in as myself (administrator signing into domain) then the files open just fine, but when I sign in as a Power User directly ...

**1**

vote

**1**answer

311 views

### Excel price function not working despite adding the analysis tool pack

I am trying to price bonds using the Excel function, PRICE(..), but the intellisense doesn't come up. The help file says to install the analysis tool pack, but this doesn't resolve the problem. I have ...

**1**

vote

**2**answers

88 views

### I hyperlinked a cell in excel 2003, formula issues?

I have a budget spreadsheet using excel 2003. I have My deposit, then all of my bills, the total, then a cell that has the difference(between the amount of deposit and the total of the bills). The ...

**0**

votes

**1**answer

1k views

### Excel aggregate functions to summarise figures against grouped column

I have a spreadsheet much like the one on this page: Painless Software Schedules
I wish to create a summary sheet with the Feature against the totals for that feature of "Orig Est", "Curr Est", ...

**3**

votes

**4**answers

7k views

### How do I convert all the cells of an excel sheet to text?

Given an existing Excel 2003 document with cells of any type (integers, text, decimal, etc), how do I convert the contents of every cell to text?
And save all these changes in the same excel ...

**8**

votes

**1**answer

10k views

### allow two possible values in a Excel cell

I would like to create a cell format for one cell to only allow the value "yes" or "no" for this cell.
How could I do this?

**0**

votes

**3**answers

134 views

### Select part of a text that exists already in an above cell

How do I get Excel to partially auto-complete a word using another that already exist in the same worksheet?
Let's say I have the word "Microsoft" in a cell and in the cell below I want to type the ...

**2**

votes

**2**answers

16k views

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

**0**

votes

**1**answer

374 views

### Excel showing hidden data?

-- Excel 2003 SP3 --
I have a spreadsheet which I know for certain has a large amount of hidden rows which are correctly hiding on my colleagues machines, and were correctly hiding on mine two days ...

**0**

votes

**1**answer

57 views

### Weird Excel bar diagram behaviour

I have a very simple question. I wanna have a diagram with the
following table
Apple 30 40 50
Pears 200 300 400
Bananas 10 20 30
The weird thing, when I try to draw a bar diagram the order ...

**7**

votes

**2**answers

94 views

### Migrating from VBA Excel 2003

I have a series of big excel files that work like a program, but I hate beeing tied up (stuck in VBA for excel 2003), so...
Whats the best way to implement a gui over a excel vba program (office ...