The 2003 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

1
vote
2answers
1k views

Excel 2003: Disable Drag and Drop on all sheets without VBA

Is there any way to disable drag and drop of cells on all sheets without a script. I know you can do it globally, there is a setting in the Excel program that disables it locally on your machine. ...
1
vote
2answers
1k views

Excel 2003 opening files on network

The network is laid out with an XP Pro computer as the server hosting files, then 3 XP computers connecting to it for filesharing, all on it's own router. One computer can open .xls files no problem, ...
0
votes
2answers
821 views

Excel files with passwords not responsive from network drive

I have a couple decent sized excel files (one 18,442 KB, another 11,088 KB) that have passwords. Yesterday I could open them without problems. Today I found my computer had restarted itself after a ...
5
votes
3answers
11k views

Excel 2010 data validation warning (compatibility mode)

We have some legacy worksheets that were created in Excel 2003, which are used by LabVIEW-based test automation software. The current LabVIEW software can only handle the legacy .xls format, so we're ...
1
vote
1answer
470 views

How to disable Flash games in Excel 2003?

Some students in my college computer lab are playing Flash games that have been embedded in Excel 2003 spreadsheets. How can I disable Flash being used in this way in Excel 2003?
0
votes
1answer
240 views

How do I sort two columns against one in Excel 2003?

I need to produce a method of moving the B and C columns to match up with A so: with a macro or formula it should produce: Column 1(A) should be unchanged but 2(B) and 3(C) moved; 2 and 3 will ...
39
votes
2answers
9k views

Excel: how to undo in current file only?

Microsoft Excel's undo / redo feature behaves unlike any other program I know. The undo stack seems to be global across all open files, so that undoing sometimes switches to another file and undoes ...
3
votes
2answers
2k views

Need formula or lookup command to find the next highest date in a list in Excel 2003

I have an excel spreadsheet that uses a variety of formulas and returns the dates that certain events will happen - actually, dates that I need to do certain things. The spreadsheet is in no order ...
2
votes
3answers
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
3answers
846 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
1answer
1k 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
1answer
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
1answer
168 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
1answer
746 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
1answer
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
1answer
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
1answer
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
2answers
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
3answers
666 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
3answers
5k 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
1answer
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
3answers
6k 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
1answer
805 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
1answer
92 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
5answers
2k 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
1answer
197 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
3answers
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
2answers
4k 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
1answer
932 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
1answer
11k 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
1answer
916 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
2answers
21k 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
1answer
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
1answer
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 ...
15
votes
1answer
44k 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
2answers
10k 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
2answers
11k 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
5answers
382 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
1answer
633 views

Does “track changes” exist in Excel 2003?

Do we have Track changes in Excel 2003?
0
votes
0answers
474 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
3answers
4k 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
2answers
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 ...
2
votes
3answers
13k 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
1answer
431 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
2answers
781 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
1answer
511 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
1answer
595 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
1answer
922 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
3answers
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
5answers
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 ...