Questions tagged [microsoft-excel-2003]

The 2003 version of Microsoft's spreadsheet application.

Filter by
Sorted by
Tagged with
0
votes
1answer
236 views

How to chart different shifts run times in Excel 2003

I have the following as an example. Date Duration Shift 4-Dec 60 1 4-Dec 40 2 5-Dec 45 1 5-Dec 55 2 5-Dec 30 3 I am trying to map these ...
0
votes
1answer
3k views

Why is Edit->Links disabled when I open my sheet?

I want to use the function to see what other spreadsheets a particular file, says MySS.xls, is linking to. But somehow the 'Link...' is disabled. I have unprotected MySS.xls. Why is it so? How can ...
0
votes
1answer
107 views

Double-Click URL to Follow in Microsoft Excel 2003?

I want to automatically follow a hyperlinked cell when double-clicked, not single-clicked. Can I configure this?
0
votes
1answer
1k views

Download direct image links in Excel 2003

I have a list of about 6,000 direct links to images in an excel sheet, and I need to download them all automatically onto my computer into a directory keeping the same file names. How do I do this?
4
votes
1answer
4k views

Zero values in Excel logarithmic chart: Can the warning be suppressed?

I'm plotting data in an Excel 2003 chart with a logarithmic scale on the Y axis. Some data points are occasionally missing, and this is represented by blank cells. The resulting graph looks like the ...
9
votes
4answers
87k views

How to avoid double quotes when saving Excel file as Unicode?

I have an Excel file with Unicode content of which some cells contain text inside double quotes, for example "text". When I save the Excel file to a text file in Unicode format, the text which ...
2
votes
1answer
166 views

In Excel, how do I highlight all rows that do not contain “,2”?

I'm verifying the FormatCurrency function is written properly in ASP code and I put everything in Excel from "find results". I want to highlight only the ones that do not contain ",2" in them. Don'...
-1
votes
2answers
70 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
87 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
2k 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
207 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
457 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 ...
3
votes
1answer
906 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
4answers
18k 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 ...
8
votes
5answers
118k 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
4k 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
244 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/...
97
votes
7answers
660k 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
2k 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
850 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
16k 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
510 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
312 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 also ...
102
votes
4answers
45k 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
6k 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
5k 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
1k 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 ...
3
votes
1answer
4k 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, ...
2
votes
1answer
5k 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
206 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
1k 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 ...
1
vote
1answer
6k 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
4k 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
8k 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 ...
1
vote
3answers
971 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
16k 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
6k 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
16k 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
975 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
109 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
225 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
8k 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
18k 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 ...