The 2003 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

-1
votes
2answers
54 views

copy worksheet to several workbook

I created a worksheet/spreadsheet with functions and references to cells in other worksheets/spreadsheets within same workbook to create a report of other worksheets within the same workbook. I have ...
1
vote
1answer
1k views

Can the Selected Excel Custom View be determined

I know I can show a custom view in excel with vba. What I need to do is determine which custom view was selected by a user, to alter a column header based upon that selection. They are using this to ...
1
vote
1answer
62 views

Take two characters from a cell

In Cell A1 I have a date format: 22-12-2011 (dd-mm-yyy). Now in A2 I want to have only the dd of A1. So I want to have 22. How can I do this?
2
votes
1answer
1k views

How to create a XY (scatter) chart with three columns of data?

I have the following data: Date Name Value 1/1/2011 FOO 10 1/1/2011 BAR 12 2/1/2011 FOO 16 3/1/2011 BAR 21 5/1/2011 FOO ...
0
votes
0answers
1k views

Recover data from corrupt excel file [duplicate]

a friend has a corrupt excel file. When you attempt to open it in excel it says "File format is not valid". None of the tricks here work. The file is Excel 2003 format. She sometimes edits it on ...
0
votes
2answers
183 views

Excel Multiple Conditions Summing

I have Column A to A1600. In that column I have two project names "CP" and "GFI", in column B I have Project Phase 1-8, in column C I have the hours worked in each phase. The projects intertwine so ...
1
vote
1answer
395 views

How to calculate the total sum of hours with automatic filter

I have an Excel sheet where I sum hours to get the total amount of my work. It works without problems, but if I add an automatic filter I'd like the calculations to be done only on the portion of ...
2
votes
1answer
737 views

Is there a keyboard shortcut to circularly switch sheets in Excel?

In this question, he was asking about keyboard shortcut to switch tabs. But this shortcut moves the sheet backward or forward, which means that pressing Ctrl+PageUp on the last sheet doesn't move the ...
5
votes
2answers
11k views

How do I force a user to use a specific format when entering time data?

I need to ensure the users of a particular spreadsheet are entering the time data in military time. I'm finding some folks are omitting the colon, and it's causing problems. Is there a way to force ...
3
votes
5answers
54k views

How to get excel row numbers to skip the header

This is really a cosmetic question. Excel by default starts counting from line one which is the header. Is there some way to have it start counting from the real line one (the line after the header). ...
1
vote
2answers
3k views

Converting a formula from MS Excel 2010 to MS Excel 2003?

In Excel 2010 the forulma I am using is: =_xlfn.IFERROR(INDEX(K$76:K$2044,MATCH(Q23,P$76:P$2044,0),1),INDEX(K$76:K$2044,MATCH(Q23,L$76:L$2044,0),1)) But I need to convert it to excel 2003. I have ...
1
vote
1answer
229 views

How to create a Pivot Graph that only looks at the Day in Month instead of Full Date?

I have an Excel spreadsheet that is defined the same way as in this question. 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/...
66
votes
6answers
309k views

Cells not updating automatically

I have a formula in a cell which counts the values in 2 other cells. Normally, after entering in the values in these 2 other cells, the formula cell updates automatically when Enter is pressed or when ...
1
vote
2answers
2k 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
835 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
13k 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
484 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
295 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 ...
54
votes
3answers
14k 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
3k 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
912 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
2k 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
3k 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
170 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 10/...
0
votes
1answer
892 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
3k 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
3k 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
4k 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
2k 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
757 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
7k 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
7k 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
868 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
97 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 like:...
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: =sum(indirect(concatenate(address(...
2
votes
1answer
208 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 ...
1
vote
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 ...
4
votes
2answers
5k 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
1k 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
14k 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
1k 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 ...
4
votes
2answers
42k 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
2answers
2k 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 sheet1....
21
votes
1answer
73k 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
14k 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 ...
4
votes
2answers
18k 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 ...