The 2003 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

0
votes
1answer
655 views

How to make Excel application load some xll files via vbs?

I need to be able to load the xlls into an instance of Excel. It is easy to do so using the GUI. Just use 'open file' dialog box and load the xll file. However, how I can script this behaviour ...
0
votes
2answers
525 views

Programmatically updated a cell's formula in one PC shows #Name in another PC

We have a lot of spreadsheets and there is a need to upgrade an important Addin. The change will involve converting an old formula to a new one. It is not a straightforward change because the name ...
1
vote
2answers
12k views

How do I group rows in a spreadsheet and keep them together after sorting?

I have a spreadsheet with the information set up as such: ORDER PLU/Recipe # Name/Desc Components 2 27905 CINNAMON CRUMB CAKE SQUARES 2.01 ...
1
vote
2answers
4k views

Can I use “Fill Down” to make a vertical series reference a horizontal series?

Say I have a data series going from A1 to E1. I would like to make a second copy of these cells going vertically, for instance from G1-G5. I can achieve what I want just by typing =A1 into G1, =B1 ...
2
votes
3answers
151 views

Convert Excel data

I've made a survey in Sharepoint and want to convert the results into something useful in Excel 2003. My problem is the format the responses are in for some questions. An example of two responses ...
0
votes
2answers
2k views

Get all linked files to an Excel 2003 document

I want to get a list of all the linked files in an Excel 2003 document, or, better still, automatically retrieve all the files linked to the document and zip them. Is such an operation possible? I am ...
2
votes
2answers
632 views

Rearranging a 15 X 25 Excel matrix into three columns

In Excel I have data in cells from A1 to O5 (15 X 25). I wish to rearrange things such that I have the following [A1][B1][C1] [D1][E1][F1] [G1][H1][I1] [J1][K1][L1] ...
0
votes
1answer
253 views

Microsoft Excel file versions [duplicate]

We have a user here who uses Word 2003 and Excel 2003 as his primary tools. He needs to keep different versions of his files over the time so he can rollback to a previous version at any time. ...
1
vote
1answer
81 views

Microsoft Excel 2003 formulas

I am trying to make a formula most of it works this is what I have so far =100%-(D62/C62) this part is great, but if D62=0 I want it to stay 0. How do I add to this formula to work?
1
vote
1answer
2k views

How to use multiple criteria with COUNTIF?

INPUT: This is the format of the OUTPUT desired: OUTPUT for example INPUT: The problem is, I don't know how to use COUNTIF with several criteria. The "dream function" [that doesn't work] ...
0
votes
2answers
258 views

Conditional Formatting Non Contiguous Ranges

I have a large spreadsheet, which came prepopulated with data. What I would like to do is the following. If I select I7:15, and apply this conditional formatting Cell Value is equal to =G7, colour ...
0
votes
2answers
258 views

Template is working for Excel2003 but not for Excel2007

I created an Excel worksheet (Book.xlt) under C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART with my own setting. That settings are occurring only for Excel2003(.xls) ...
0
votes
1answer
437 views

Disply zero value in cell in excel

Is there any other way to display zero value in excel without using ' before zero. with zero before ' then it show zero in excel
2
votes
7answers
18k views

Adding more than 15 digits in Excel

I want to add more than 20 digits in an Excel cell. The current format of the cell is general, it converts the number to an exponential format. I tried with a number format and accounting, but when I ...
0
votes
2answers
388 views

Properties of cell editor in excel

How to make excel cell editor property as text by default in excel. Actually cell property is general.How can i make that as text in excel (Right click on excel cell editor click on format cell ...
5
votes
4answers
59k views

How to open ods files in Excel?

What is the best way to open ods files in Excel 2003? Is there some plug-in available? Should I use some convertor to xls? Or would it be best if I just used LibreOffice (or OpenOffice)? The file I ...
1
vote
1answer
894 views

How to dynamically link a spreadsheet to another

I have two spreadsheets in the same workbook. Users are entering data in a table of the Sheet1 and I would like to duplicate that same table in the Sheet2 dynamically. In other words, I don't want to ...
1
vote
2answers
4k views

Link two excel workbook located in different computers

I have two excel workbook The first one located in one computer (i.e. "\192.168.7.1\Shared\book1.xls") The second one in another computer (i.e. "\192.168.7.2\Shared\book2.xls") With both spreadsheet ...
0
votes
2answers
1k views

Remove duplicate rows in excel when not all the columns are the same

How can I automatically remove duplicate rows in Excel when data->filter doesn't work, because the columns aren't all the same? I believe the picture explains what I need, but I can probably supply a ...
1
vote
2answers
378 views

How could I get the text defining an Excel formula for one cell into another cell?

In other words, if the value of a cell, say A1, is =Date(), then displayed in cell A1 I will see the date, but then I want B1 to be =FuncText(A1), then I want to see 'Date()' displayed in cell B1. To ...
6
votes
2answers
23k views

Merge two excel files using a common column

I have two excel sheets. I have to merge the two such that the values in one match with the other. For eg. The first excel, the 2nd excel 1 t 1 tes1 2 5 3 ...
0
votes
1answer
118 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
522 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
38 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
752 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?
2
votes
1answer
1k 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 ...
4
votes
5answers
13k 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
96 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. ...
0
votes
2answers
52 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
816 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
53 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
817 views

Recover data from corrupt excel file

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
148 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
331 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
584 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
6k 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 ...
2
votes
3answers
21k 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). ...
0
votes
2answers
2k 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
221 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 ...
42
votes
3answers
14k views

Cells not updating automatically

I seem to have a problem with an excel file. I have a formula in a cell which counts the values in 2 other cells, however, normally after entering in the values in the 2 other cells, the formula cell ...
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
817 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 ...
4
votes
3answers
10k 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
450 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
236 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 ...
33
votes
2answers
6k 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
1answer
1k 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
2k 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 ...