The 2003 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

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 ...
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 ...
1
vote
2answers
2k views

Format Change Event for Excel VBA

I'm trying to prevent people from modifying (most) of my spreadsheet while still alowing them to use the sort function of the AutoFilter. What I've done so far is used the Worksheet_Change event and ...
0
votes
2answers
269 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) ...
-1
votes
2answers
212 views

I will need a formula showing counts, totals and sub-totals for data set from different sheet

I am using MS2003 EXCEL. I have a cell in Sheet 1 with a color value and totals, with sub-totals. On sheet 2, I have a data set with 3 columns (colors, dress, type). On Sheet 1, I will need a ...
2
votes
1answer
732 views

Divide pivot table data by an arbitrary column in another table

I have this data from a pivot table: Countries P1 P2 Total Country 1 10 69 Country 2 36 2 92 Country 3 21 24 100 Country 4 22 77 Country 5 13 79 Country 6 12 1 ...
1
vote
1answer
231 views

How to create a two column pick list in Excel

I want to be able to have a pick list with two columns setup in a worksheet and pick from that list in another worksheet to populate two columns. Pick List Sheet would look like this A Item 1 ...
1
vote
1answer
366 views

Source File not updating Destination Files in Excel

I have one source file that holds all my input costs. I then have 30 to 40 destination files (costing sheets) that use links to data in this source file for their various formulae. I was sure when I ...
1
vote
1answer
225 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
1answer
95 views

How to make sure that the text in TextBox in an excel is found when searched using CNTRL+F?

i have made a flow chart diagram in an excel sheet using TextBox tool from drawing toolbar. i've made entries into the text boxes.(No other data is present in the cells of the worksheet) But now ...
0
votes
1answer
41 views

How does the user make a selection in MSExcel that contains only those cells that contain data?

Got an MSExcel question for you. he specs for my computer are: Intel Inspiron laptop i3-2.20ghz , 8GB DDR3, 400GB HDD, Win 7 Prem. And the version I am using is MSExcel 2003. My question has to do ...
0
votes
1answer
41 views

Excel Validation Feature to Return Items from a List

I have a list of bank code and bank description in spreadsheet. i wanted to select a bank code from a list and then display the bank's description. How can i perform this ? Sorry im new with excel ...
0
votes
1answer
348 views

Spread Sheet Formula for Time Study

I need to create an excel spread sheet. I am doing a time study. ( The time a project was started to finish) I will be entering in times frequently in military time. I havent used excel for years and ...
0
votes
1answer
54 views

Data entered into cell replicates in all sheets unneccesarily?

Example: I enter data into sheet 29 cell 7, then cell 7 from 1-31 shows the same data. How do I undo this? It was not a problem yesterday. There is no formula in the cell.
0
votes
1answer
617 views

Excel - compare names in two cells in different order

I need to compare the following Cell 1 John Peter henderson Cell 2 peter John Henderson Result Match Cell 1 Anne jolie ...
0
votes
1answer
90 views

Close Full Screen window does not go away in MS Excel 2003

I have a problem or bug in MS Excel 2003 where the close full screen mini window does not move or go away. No matter what I do, I cannot move the window or even click any of the options. I'm ...
0
votes
1answer
301 views

Excel 2003 Macro runtime error 1004 application-defined or object-defined error

We are using a macro to remove rows of data from our excel 'database' that have been tagged as being completed/done. this is the coding ... Private Sub cmdRemove_Click() Dim varResult As ...
0
votes
1answer
258 views

excel 2003: file too big even its empty

I have one excel file that consist of 3 sheets. Each sheet consist of text and image. The file grow up until 171KB. Then I copy one sheet become single file and save as a new file (newbook.xls). And I ...
0
votes
1answer
146 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
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 ...
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 ...
0
votes
1answer
919 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 ...
0
votes
1answer
924 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?
0
votes
1answer
406 views

Excel showing hidden data?

-- Excel 2003 SP3 -- I have a spreadsheet which I know for certain has a large amount of hidden rows which are correctly hiding on my colleagues machines, and were correctly hiding on mine two days ...
-1
votes
1answer
356 views

Macro to count the number of text strings in sheet in Excel 2003

I have a worksheet for scoring. I have a list in the first sheet that will be for data entry starting with a2 and going down the sheet, this is for Player names. I have a summary sheet named "Place" ...
-1
votes
1answer
94 views

How to merge data B and C cell into A cell and applie the same to all rows

I have a data in Column A1 some data and I want to combine data from Column B1, D1 and E1 to Coumn A1, how do I do it using macro in excel 2003.
2
votes
0answers
216 views

Why is the maximum row height in Excel 546px?

The maximum height of a single row in Excel 2003 is 546 pixels, or 409.5 points: http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP005199291.aspx I'm curious as to why ...
1
vote
0answers
17 views

How to prevent enabling editing in Protected View in Excel 2013 from altering chart formatting of Excel 2000-2003 and 2007-2010 workbooks

In Excel 2013, when opening and enabling editing from Protected View a macro-enabled Excel workbook downloaded from the internet, with two versions in .xls (Excel 2000-2003) and .xlsm (Excel ...
1
vote
0answers
201 views

Extracting and collating data from multiple columns in Excel 2003

First of all I have tried a lot but failed to get a solution for the following problem and I hence request all the superusers to help me with their best if possible.... I tried unpivoting but it did ...
1
vote
0answers
567 views

Opening an Excel 2003 workbook in Excel 2010 32-bit causes bogus circular reference and crashes

We have a workbook that we have been using daily for many years in Excel 2003. We are now migrating to Excel 2010, and have encountered the following problem. When the workbook is opened in 2010 ...
1
vote
0answers
172 views

Opening an Excel 2003 workbook in Excel 2010 32-bit causes bogus circular reference and crashes

We have a workbook that we have been using daily for many years in Excel 2003. We are now migrating to Excel 2010, and have encountered the following problem. When the workbook is opened in 2010 ...
1
vote
0answers
353 views

Macro to copy and insert rows by variable number

I have an Excel 2003 worksheet with names and addresses, unique per row, to be used for shipping monthly magazines. Some members receive more than one copy of the magazine, which will be indicated in ...
1
vote
0answers
87 views

How to validate formulas easily in Excel 2003?

When reviewing Excel spreadsheets done by others, I have to do the work of validating all formulas contained in the workbook. It's a frustrating, time-consuming process to trace the quoted cells, ...
1
vote
0answers
1k views

How to Search For Excel (2003) Files which Contain Macros on Server?

How can I search for Excel files that contain VBA code, are there any efficient ways to do this? The way I'm thinking of would be to use vbscript and recursively search through the directory, open ...
0
votes
0answers
23 views

Vertical line excel chart

How is possible to draw in MS Excel (starting from 2003) charts like this Seems incredible that basic things like this be hard to do in Excel I read this article but it involves other 2 helper ...
0
votes
0answers
12 views

LWD, WTD and MTD Split

All, I have a list of data and I would like to do a summary table that automatically calculates entries for the last working day, week to date and month to date. Sample below. So in my summary ...
0
votes
0answers
44 views

How do I format numbers with abbreviations in Excel 2003?

In Excel 2003, is there any way to format positive numbers with abbreviations (specifically K, M, & B) while displaying all decimal places but not trailing zeroes like so: 878.1K 100M 1.478B ...
0
votes
0answers
28 views

Cannot use Buttons with VBA in 2003 but can use buttons from same sheet in 2010 Excel

I have excel 2003 and 2010 installed on our computers. I reinstalled both, did a system restore. I manually uninstalled all updates from the past month (this started happening 1-1.5 weeks ago) I am ...
0
votes
0answers
84 views

Broken ActiveX in Excel 2003

I hope this is the correct forum to post this, I believe this to be an Excel issue. Ever since I upgraded to Win 7 (64 bit), whenever I try to add an ActiveX control to a worksheet in Excel 2003, I ...
0
votes
0answers
59 views

Show Excel column filter information in cells - Not working

I am on a W7 64bit pro edition, on a Lenovo T420 With regard to Show Excel column filter information in cells, is there a reason why it is not working in Excel 2003? Thanks in advance Gilberto PS I ...
0
votes
0answers
14 views

Excel experiencing one-time delay during saving and quitting

On my work machine I have Excel 2003. The first time (per instance) I try to save a file or quit, there is a noticeable delay. For saving the delay is somewhere around 10-15 seconds and for quitting ...
0
votes
0answers
34 views

Query priority .xls VS .mdb

Hello to all the superusers! My new question regarding conflict problem betweend an access application ad a excel wookbook/worksheet I have a worksheet where using "Get External Data" on the "Data" ...
0
votes
0answers
61 views

How do I pull rows from one sheet to another sheet automatically as data changes?

I currently use excel to create a shopping list to make it easier at the store. All rows have an item name, cost, and total based on the qty entered in the A column. Is there any way (with little to ...
0
votes
0answers
35 views

Why does Excel 2007 change 13 to 14 when typed in?

Every time my co-worker types 13 into an excel cell, excel changes it to 14. She was using excel 2003 and this was happening. Our tech installed 2007 and it is still happening. We have to use a ...
0
votes
0answers
51 views

MIcrosoft excel 2003 auto populate cells

What I would like is input text into a cell say A1 and I want that text to then be duplicated in cell D1. But I can not type the formula into D1 itself i.e. no =a1. Is this possible? Thanks
0
votes
0answers
31 views

Windows Xp, Excel 2003 automatic start on bootup and yes to update

I need to start an excel file on startup. However when opening the software always ask if the user wants to update the files. How can I get Excel to automatically do this every time?
0
votes
0answers
85 views

Entering a null value from the keyboard or using menus

How do I insert a NULL value into a cell using the keyboard or a menu option? For example, in some programs, typing CONTROL + 0 results in a null value being inserted and the text "NULL" being ...
0
votes
0answers
970 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
0answers
476 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?