Questions tagged [microsoft-excel-2003]

The 2003 version of Microsoft's spreadsheet application.

48 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
2answers
5k 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 ...
2
votes
1answer
1k 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
0answers
205 views

Difference between VBA for Excel 2003 running on Windows 10 and Windows 7

Okay, I have an oddly specific situation: I made a bunch of macros and Visual Basic code in an Excel 2003 Spreadsheet running on Windows 7. The product has been working perfectly for one and a half ...
1
vote
0answers
51 views

Whenever I open specific Excel binary file computer turns off without warning

Whenever I open an Excel binary file my computer turns off without warning. Even after repairing office the same issue persists. I can open other Excel files. How can I resolve this?
1
vote
1answer
61 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
0answers
44 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
260 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
1answer
759 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 ...
1
vote
0answers
282 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
290 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
920 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
794 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
90 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
2k 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 ...
1
vote
1answer
691 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
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/...
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
637 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
2answers
124 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
16 views

Excel 2003 in Windows 10 - single instance/dde?

I'm running Windows 10 and Excel 2003 (it runs much faster than newer versions of excel). The problem is that I generally prefer most files to open in the same instance of excel. Is there any way to ...
0
votes
0answers
49 views

2003 Excel Formula conversion to 2010 Excel formula

I am creating a payments spreadsheet to accurately calculate interest on overdue payments. My formula used in the 2003 version that I am trying to copy into an updated version is: =zInterest(...
0
votes
0answers
172 views

Creating Cluster Column and Line Graph in Excel

I have created a clustered column chart where I inverted value so the series became the "categories" and the dates became series and just manually adjusted the coloring. I have attached an image. ...
0
votes
0answers
75 views

How to recover a .xls file that turned into .xls.XML file? - in windows 10

Can you please help me with this one? I have read few articles and questions here and there but there seems to be no answer at all. I have an excel file (sample.xls) that turned into sample.xls.XML ...
0
votes
0answers
76 views

Excel File Open Dialog Crash when selecting My Computer

In Excel 2003 using the File Open Dialog Selecting the My Computer or My PC from the dropdown selector crashes Excel everytime. This does not happen if other folders are selected. Have seen mentions ...
0
votes
1answer
416 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
0answers
63 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
1answer
2k 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
105 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
0answers
25 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
1answer
3k 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
0answers
64 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
1answer
68 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
1k 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
156 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
431 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
0answers
38 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
128 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
1answer
274 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
2answers
280 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
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
2k 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
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:...
0
votes
0answers
666 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?
0
votes
1answer
426 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
577 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
107 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.
-1
votes
2answers
451 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
678 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....