The excel-2003 tag has no wiki summary.
1
vote
1answer
43 views
why does excel 2007 format date and “serial value” when applying the normal style
Why does Excel 2007/2010 remove the format of a date when applying the Normal style when it didn't in previous version?
For example, if I have 1/1/2012 and apply the Normal style, I end up with ...
0
votes
1answer
19 views
Microsoft Excel file versions
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
2answers
47 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?
0
votes
0answers
27 views
How to use multiple criteria with COUNTIF? - MS Excel
INPUT:
What is the format of the OUTPUT that we need:
OUTPUT for example INPUT:
So the problem is, I don't know how do I use COUNTIF with several criteria!
The "dream function" [that doesn't ...
1
vote
0answers
35 views
Sort and filter by one column of a pivot table instead of the Grand Total
I have an Excel file featuring a pivot table. For reference, the file was made in Excel 2003, but I am running 2010. The file has to continue to be compatible with Excel 2003.
Because I cannot ...
0
votes
2answers
53 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
56 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
36 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
1
vote
3answers
94 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 ...
0
votes
2answers
49 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
...
4
votes
3answers
122 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
49 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
1answer
43 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
0answers
17 views
Pivot table causes Excel to stop working
After printing a pivot table report, Excel frequently becomes unresponsive. Has anyone noticed something similar or knows what the problem might be?
0
votes
2answers
98 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
50 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 ...
0
votes
0answers
15 views
Excel Chart - Unable to input source data from 1 out of every 7 rows in my sheet
I am trying to create a chart to show weekly data but my spreadsheet is set up to show one row (with a total for the week) and then additional rows underneath displaying the daily info. I'm trying to ...
0
votes
1answer
39 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
12 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
41 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
0answers
59 views
Embed the EXE file in the excel file itself
I use:
retVal = Shell("program.EXE " & filename, vbNormalFocus)
To execute a program need for my excel spreadsheet.
Is it possible to embed the EXE file in the excel file itself?
And how ...
0
votes
1answer
17 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
46 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? ...
1
vote
0answers
77 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 ...
2
votes
2answers
148 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 in Unicode format, the text which contains the double ...
0
votes
0answers
50 views
Why can't I drag and drop Outlook 2003 emails into Excel 2003? [closed]
I can drag them into word and visio, why not excel?
1
vote
1answer
29 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
26 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
122 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 ...
0
votes
0answers
23 views
“pin” cells from a filtered range in Excel 2003 chart?
I have a chart created by selecting a range from a table filtered by some values.
Now if I change the filtering, the chart changes dynamically.
How do I opt out of this behavior, i.e. fix the cells ...
1
vote
1answer
23 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?
1
vote
1answer
175 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
87 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
47 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
41 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
77 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 ...
4
votes
1answer
122 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 ...
0
votes
2answers
64 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
39 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
...
1
vote
2answers
46 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
525 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
665 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 ...
2
votes
1answer
457 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
103 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
0answers
49 views
Problem with Dates in Excel 2003 from Access 2007
The user gets the front end of Access 2007 from an outside entity. We have no ability to put code in it to export/create a spreadsheet. She exports data to an Excel 2003 format, which includes dates. ...
0
votes
1answer
74 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 ...
18
votes
2answers
448 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 ...
0
votes
0answers
39 views
Excel footers disappear
I have a user I support who says she prints out an excel 2003 spreadsheet with footers and in landscape format. She saves the file, then copies it, however the copied file reverts to portrait and ...
3
votes
1answer
66 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 ...
1
vote
3answers
249 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 ...
