The 2003 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

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
2answers
3k 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
275 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
279 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
2answers
406 views

How do I convert list to table in Excel 2003

I have a list: date item name quantity 1.7.2014 A 5 1.7.2014 B 2 1.7.2014 C 10 2.7.2014 B 5 3.7.2014 A 1 4.7....
2
votes
1answer
872 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
20 views

Can a single cell in Excel extend over several pages? How?

I encountered this problem while trying to write really large chunks of text in Excel. In spite of of wrapping turned on, my text doesn't really get wrapped once it stretches over more than 12 lines (...
1
vote
1answer
292 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
446 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
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/...
1
vote
1answer
97 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
36 views

How to express a lone “\” in a file path in VBA?

I'm using a VBA script to save a file titled "month-day-hour-minute" inside of a folder titled "month-year" Anyways, excel doesn't like my code, ActiveWorkbook.SaveAs "C:\Users\" & Environ$(...
0
votes
1answer
36 views

Merge two Excel spread sheets using a common column and retaining duplicates

There are two excel sheets. I am trying to merge the two files based on the id column. For example: first excel: id var1 var2 var3 1 5 4 5 2 3 2 2 ...
0
votes
1answer
77 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
109 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
1answer
1k 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
61 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
808 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
108 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
374 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
262 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
189 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
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:...
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 ...
0
votes
1answer
417 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
429 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
96 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.
4
votes
0answers
569 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
35 views

excel 2003 support with cell formatting

Please help. I have created a borrowing excel worksheet to monitor borrowing books. I want to fill a cell (column B) with a date when an item is returned and then have that row move to the bottom of ...
1
vote
0answers
112 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 2007-2010)...
1
vote
0answers
261 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
695 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 (32-...
1
vote
0answers
223 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 (32-...
1
vote
0answers
435 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
13 views

Excel 2003 - How do I link sheets in different workbooks when there are path issues?

I've created several Workbooks relating to the same project and now want to create a master workbook that contains the results from each of the others. The problem that I have is that the formulas do ...
0
votes
0answers
43 views

How do I make form fill out to different sheets based on the month?

I have an exercise and diet log that I fill out every other day and I want the data to move to another sheet. Sheet 1 looks like a worksheet and I want it to move (I think the best way to do this is ...
0
votes
0answers
8 views

excel vs access query priority

Hi Superuser this is my question Scenario: -an Access 2003 based application to manage the stock; the application had several mask to peform the update of different .mdb table. -an Excel 2003 ...
0
votes
0answers
7 views

UDF to make cell temporarily wider

In Excel 2003, I have the following UDF which makes a column temporarily wider. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Count > 1 Then Exit Sub If Target....
0
votes
0answers
15 views

Right click and menu bar drop down list not visible when clicked

It would be great if anyone could solve this for me. When I click on the Menu Tab or right click the list doesn't drop down. I can just about see a faint outline where the list is supposed to drop ...
0
votes
0answers
94 views

Excel 2003 - Matching and summarising data across multiple worksheets

I am looking for help regarding my roster calculations. I have built a roster over 13 worksheets plus a calculation worksheet. On each sheet column D has a list of names populated from an offset ...
0
votes
0answers
94 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
37 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
19 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
42 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
55 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
97 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
522 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?