The 2003 version of Microsoft's spreadsheet application.
1
vote
2answers
558 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
770 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 ...
3
votes
3answers
5k 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
315 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
193 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 ...
21
votes
2answers
2k 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
286 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
1k 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 ...
1
vote
3answers
675 views
How do I use a linked cell in Excel in a formula?
I am trying to create a formula using a cell that holds data linked from another tab in the same spreadsheet. When the source cell is blank, the linked cell shows "0". Is there a way to have the ...
2
votes
1answer
330 views
Random Excel bug when referencing a different sheet
I am getting a very strange error anytime I try to use a formula pointing to a cell in a different sheet from the active one (even as simple as "=Sheet2!A1"). This started happening all of a sudden, ...
1
vote
1answer
488 views
Drag-and-drop a new series onto an Excel chart
In Excel 2003, I can select a new data series and drag it onto an existing chart to add it to that chart. In Excel 2007 I can't. Does anyone know if this functionality was removed or if it is ...
2
votes
1answer
135 views
I would like the dates to appear on the X-axis and the colour category to apear on the Y-axis, Excel
There is probably a fairly straight forward answer out there but I can not seem to find a solution online.
I have a table marked up like this (column names are in bold)
audit date | blindness
...
0
votes
1answer
312 views
VBA xlColumnDataType in Excel 2003
When importing a txt file into excel, I need to specify data types for the columns.
I'm currently using Excel 2003 (upgrade to 2010 is for later in the summer).
I have been able to find enumerations ...
0
votes
1answer
839 views
In Excel VBA Macro does ActiveWindow.Scroll change ActiveCell at all
I'm cleaning up and extending some excel VBA macros (written and currently running in Excel 2003), and I have a question about how far I can go in cleaning up without modifying the output.
There are ...
3
votes
1answer
1k views
Excel 2003: open spreadsheet and run macro from command line
The need: run a macro within an excel 2003 file every week, automatically, than save the file.
The approach: add an action to task manager for every week, calling the file with command line ...
0
votes
1answer
579 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 ...
1
vote
2answers
689 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 ...
0
votes
3answers
443 views
Open Excel 2003 XML files (XMLSS) in Excel 2000
I need to open Excel 2003 XML files (not Open XML from 2007) in Excel 2000. Is there any plugin that would allow me to do this?
Edit: the name of the format is called XMLSS - XML Spreadsheet
0
votes
3answers
2k views
Move markers of line chart/ Format legend
I have a combination chart with a bar chart and 2 line graphs on secondary axis. have to exactly match the formatting in the screenshot attached ( I do not have the actual excel file. just have a ...
2
votes
1answer
1k views
Excel (.xls) files not opening in Excel when launched from Explorer
I appear to have done something to Excel (2003) whereby whenever I double-click on an Excel file (.xls) in Windows Explorer, Excel launches OK, but the corresponding workbook doesn't open, and I'm ...
3
votes
2answers
3k views
255 Character limit on VLOOKUP
Using excel 2003, the formula:
=VLOOKUP(D1 ,A1:B135, 2)
fails if the length of D1 exceeds 255 characters (i.e. the list has some text longer then 255 characters, D1 has the same text value, and ...
2
votes
1answer
558 views
How to filter out data between two columns?
I have data in my excel sheet in the below format
A B
1 2
2 3
3 5
4 8
5
6
7
8
9
i.e colA has values 1 through 9 and colB has 2,3,5,8. Now what I need in ...
0
votes
1answer
75 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 ...
2
votes
5answers
817 views
Excel not properly recalculating values
I have an Excel sheet with values in it (this sheet is generated by a custom perl script, but I don't think that's where the problem lies). In it, I have a formula:
...
2
votes
1answer
166 views
Returning Shapes to Default in Excel
I have around 70 shapes in a planning document i use for work, everything is fine but i am trying to add a new feature. These shapes are changed using edit points each week to show up on a map, but ...
0
votes
3answers
1k views
Excel 2003 lag under Windows 7
I'm running Excel 2003 under Windows 7 64-bit. Even on a blank spreadsheet, Excel 2003 will lag or freeze up every 10 seconds or so and every time I insert a value in the spreadsheet. I have ...
1
vote
2answers
1k views
Excel 2003 - how do I dock\fixate a row\column?
how do I create a docked row\column so that when I scroll down\right, I can still see that row?
0
votes
1answer
598 views
Excel file with macros saved in 2007 crashes when opened in 2003
My team keeps a large Excel file on a SharePoint server. Recently I've edited this file with Excel 2007 and saved it. Afterwards, everyone who opened the file with Excel 2003 and chose to "Enable ...
1
vote
1answer
4k views
Excel: Calculating working hours between two dates
Summary:
I know that the function NETWORKDAYS can be used to find the number of business days (=excluding weekends and holidays) between two dates. But what if I want to know the number of business ...
0
votes
1answer
432 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 ...
1
vote
1answer
1k views
Fill an area between two lines in a chart in Excel
There are a lot of hacks to fill the area between two lines in a chart; however, I want one that works seamlessly between 2003/2007 and mac 2011. Preferably, something that is not a hack.
2
votes
1answer
724 views
In Excel, how to group data by date, and then do operations on the data?
I have Excel 2003. My data is like this:
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/2010 0.99
etc. In fact it is a list of ...
2
votes
1answer
489 views
Macro name being changed in Excel
I am creating VBA macros in my Excel spreadsheet. I notice that from time to time (after saving the spreadsheet and reopening it, usually) one or more of the macro names is being changed from ...
10
votes
1answer
10k views
How do I put logical operators in an Excel =IF Formula?
I'm trying to enter a formula to display text according to an IF condition. The best I can manage is something like...
=IF(myval>=minval & myval <= maxval, "OK", "Not OK")
But this ...
1
vote
2answers
4k views
Color drop down in Excel cell (with no text)? e.g. bgcolor = Red-Green-Amber-unknown
I have an Excel sheet that I'm using to keep track of the status of certain things.
I want to have a column which consists of cells containing a repeated drop down that allows you to select (as ...
1
vote
2answers
2k views
Excel - Chart that sums the values in multiple rows for each series
Suppose I have a spread sheet that looks something like this...
Now, I'd like to create a column chart that has 3 series, one for each country. Then, I want series for each category, but I want to ...
2
votes
5answers
244 views
Converting date format in formulas in Excel
what is the formula which would enable me to calculate the difference between 2 dates and 2 times? Example: In the same cell, I have 01 January 2005 07:30 and in a second cell i would have 06 January ...
1
vote
1answer
383 views
0
votes
0answers
354 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?
1
vote
3answers
2k views
How to count the number of occurrences of all cell values in a specified range
I have an Excel worksheet with one column of cells with any string values, so, like this: A, B, A, D, C, C, A, A. What I am wanting to do is to count how many times each value occurs and print that ...
2
votes
2answers
981 views
Refresh values in Excel 2003
I have an excel file with three worksheets(ws), the first two have raw data and the third one contains formula to compare the data in other two ws. For example, here is an example of my comparison ...
0
votes
0answers
245 views
Remove password of excel sheet [duplicate]
Possible Duplicate:
Recover Sheet Protection Password for and Excel Sheet
How to remove/recover the password for the excel sheet online for free?
2
votes
3answers
9k views
Excel 2003 upgrading to Excel 2010, will it break our models?
My office is upgrading from Excel 2003 to Excel 2010 and we have a lot of tools in Excel 2003 (complex custom formulas, named ranges, VBA, pivots... almost every feature of excel can be found in at ...
0
votes
1answer
347 views
how do I make a sum total to always show up on below the last populated cell in a column
I am making an invoice template that pulls data from an external source. The amount of customer order line rows are variable, so I would like the sum total figure to sum all populated cells in ...
2
votes
1answer
269 views
Using excel sheet as a function
I wonder how I can use an excel sheet as a function.
Let's say I have a complex calculation in Sheet1 with one parameter I would like to iterate over a range like [1 to 400] in a second sheet to ...
1
vote
1answer
307 views
Excel 2003 doesn't undo after saving
Every time I save changes on Excel, it doesn't allow me to undo the changes I did before saving. Is that the normal behaviour of Excel 2003 or I have some weird seetting done?
1
vote
1answer
443 views
Excel 2003 Insert Function Wizard Animation Lag/Delay/Stuttering
I'm using MS Excel 2003 on Windows 7. I get animation lag anytime I open or close the Insert Function Wizard. I'm running on an ATI Radeon HD 4870 with the latest drivers (Catalyst 10.8 -- ...
0
votes
1answer
506 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?
4
votes
2answers
731 views
How can I change the z-order of data series on the secondary y-axis relative to those on the primary y-axis in Excel 2003?
In Excel 2003, it's possible to change the z-order (i.e. what plots on top) of data series plotted on an axis by right-clicking a point of one of the series, choosing "Format Data Series", and then ...
