The 2003 version of Microsoft's spreadsheet application.
1
vote
1answer
453 views
Conversion Pdf 2 Excel
Hello to everyone and thank you in advance to all the superusers that will help me.
I need to find a freeware (not trial) able to convert a pdf document on a excel sheet. Could the superusers ...
1
vote
1answer
128 views
Real time Export of excel 2003 fields to MS word 2003 fields
I am a practicing radiologist. We enter patient information such as Name, date of birth, number (patient ID), referring physician's name, and date of the study at the front desk in MS Excel 2003. Is ...
1
vote
1answer
1k 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 ...
4
votes
1answer
6k views
How to change font color in Excel based on cell value?
How do you change the font color of a column of cells based on their entered value? I've got a column with the heading at row 1 and the values starting at row 2 going on down. I want to change font ...
0
votes
2answers
2k views
How to have sequential numbers keep writing themselves?
At work, we use Microsoft Office 2003, and we have to write many numbers that are sequential, e.g. 2590, 2591, 2592, etc. These numbers are either in Excel or in a Word table.
How can I ...
1
vote
1answer
603 views
De-pivot excel spreadsheet
Using Excel 2003 Can i...
Given a spreadsheet of this layout with Permissions being Read = R , Write = W and No permission= X
Users Perm1 Perm2 Perm3 ... ..... PermX
User1 R ...
2
votes
1answer
445 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
7k views
Excel “This workbook contains links to other data sources”
I am getting this pop-up in Excel 2003, "This workbook contains links to other data sources", with the options to "Update" or "Don't Update". The workbook is using VLOOKUP to get information from ...
1
vote
2answers
546 views
Remove Excel 2003 macros easily
I am using Excel 2003 and I have some workbooks that I have to send several days a week to some recipients.
These workbooks have macros in it and I don't want the people receiving the file to be able ...
2
votes
3answers
3k views
How do I exit Excel full screen after switching desktops using MSVDM
When I switch desktops with MSVDM (Microsoft Virtual Desktop Manager) Excel goes into some kind of full screen mode, where no tool bars or menus are visible in the Excel window. Then I can not find ...
1
vote
6answers
2k views
Extend the number of rows in Excel 2003 beyond the allowable 65k
I'm stuck with excel 2003 at the office, I was wondering if there is a way to extend the number of rows to at least a million or two.
1
vote
2answers
192 views
converting custom number h:mm into time
I have time values entered in Excel as a custom number h:mm. I would like to convert these to a format (still displayed as h:mm) which will allow me to perform calculations using the data. Any ideas?
0
votes
1answer
153 views
Moved files only opening as 'read-only' in Excel
I moved a large directory of Excel files to another machine. When I sign in as myself (administrator signing into domain) then the files open just fine, but when I sign in as a Power User directly ...
1
vote
1answer
277 views
Excel price function not working despite adding the analysis tool pack
I am trying to price bonds using the Excel function, PRICE(..), but the intellisense doesn't come up. The help file says to install the analysis tool pack, but this doesn't resolve the problem. I have ...
1
vote
2answers
71 views
I hyperlinked a cell in excel 2003, formula issues?
I have a budget spreadsheet using excel 2003. I have My deposit, then all of my bills, the total, then a cell that has the difference(between the amount of deposit and the total of the bills). The ...
0
votes
1answer
1k views
Excel aggregate functions to summarise figures against grouped column
I have a spreadsheet much like the one on this page: Painless Software Schedules
I wish to create a summary sheet with the Feature against the totals for that feature of "Orig Est", "Curr Est", ...
3
votes
4answers
2k views
How do I convert all the cells of an excel sheet to text?
Given an existing Excel 2003 document with cells of any type (integers, text, decimal, etc), how do I convert the contents of every cell to text?
And save all these changes in the same excel ...
4
votes
1answer
4k views
allow two possible values in a Excel cell
I would like to create a cell format for one cell to only allow the value "yes" or "no" for this cell.
How could I do this?
0
votes
3answers
132 views
Select part of a text that exists already in an above cell
How do I get Excel to partially auto-complete a word using another that already exist in the same worksheet?
Let's say I have the word "Microsoft" in a cell and in the cell below I want to type the ...
0
votes
2answers
8k views
Excel: how to add cells to named range
I have a named range for 3 cells in excel 2003
I need to insert 1 more cell into this named range
how do I achieve this in excel 2003
0
votes
1answer
308 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 ...
0
votes
1answer
52 views
Weird Excel bar diagram behaviour
I have a very simple question. I wanna have a diagram with the
following table
Apple 30 40 50
Pears 200 300 400
Bananas 10 20 30
The weird thing, when I try to draw a bar diagram the order ...
7
votes
2answers
89 views
Migrating from VBA Excel 2003
I have a series of big excel files that work like a program, but I hate beeing tied up (stuck in VBA for excel 2003), so...
Whats the best way to implement a gui over a excel vba program (office ...
2
votes
5answers
228 views
troublesome microsoft excel 2003
Hi I have a problem with my excel .. I want to paste one bunch of rows to another excel document and I can't do it with simple copy/paste ..
I can copy then paste to notepad then
copy again and ...
4
votes
2answers
4k views
How to copy a single cell into multiple worksheets in Excel?
I have about 30 worksheets, and I need to put my name on the top left corner (cell A1). Is there an easy way to do this without having to write it or paste it into every worksheet?
1
vote
1answer
238 views
How to prevent Excel from corrupting certain data when copy-pasting from Word to Excel?
I need to copy & paste a large table (54 pages of data) from Word to Excel.
Works great except when some of the cells contain ranges (1-10, etc), Excel insists on interpreting them as dates and ...
2
votes
1answer
674 views
How to retain background colors when pasting between documents in Excel
I have a script that programatically generates excel spreadsheets - cleaning up ugly reports that are given to us from another organisation. For interests sake; I'm using PHPExcel to generate the ...
0
votes
1answer
183 views
Default print margins on Excel 2003
How can I set the default print margins on Excel 2003? I have to do it on a localized (Italian) Execl version.
2
votes
2answers
426 views
Excel 2003 Alphabetic Sort Order Is Not My Idea of Alphabetic
I have an Excel 2003 spreadsheet that I'm sorting on the first column, which is formatted as Text. The sort order is strange. Here's a "sorted" example. I've highlighted the anomaly.
120-BDXX
...
2
votes
3answers
2k views
How to add URL in a cell comment using VBA?
I am using Microsoft Excel 2003 wherein i have a cell which has a comment. The comment has text as well as URL. Is it possible to create a hyperlink (URL) in comment box where user can click and it ...
1
vote
1answer
68 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 ...
9
votes
5answers
25k views
Export an Excel spreadsheet to fixed-width text file?
Excel has the functionality to import fixed-width text files where it presents a dialog that lets you choose where the begins and ends of fields are which it puts into columns.
Does it also have ...
0
votes
1answer
783 views
calculate positive and negative times in excel 2003 (new) [duplicate]
Possible Duplicate:
calculate time differences in excel 2003
i have a goal of 2h47m00s minutes per month. if i attend let say 1h20m00s and when my excel cell format is ...
1
vote
4answers
1k views
calculate time differences in excel 2003
I have a goal of 2h47m00s minutes per month. If I attend let's say 1h20m00s and when my Excel cell format is:
[Red]-[m]:ss;[Blue][m]:ss
...then it gives me in red color 87 minutes time difference ...
0
votes
2answers
971 views
Opening an Excel document outside of browser with IIS 6
I have links to various Excel documents on an intranet site. I want these documents to open in Excel and not within the browser but i cannot figure out how to accomplish this.
In IIS 5 i could do ...
4
votes
4answers
13k views
How to get time difference as minutes in Excel?
I have time values in two cells in an Excel sheet and I need the difference of
the times in minutes.
The cells in the Excel are like below:
A B C
1 6:38 8:23 1:45:00
A is ...
0
votes
5answers
556 views
Calculate the sum of numbers in column G of MS Excel sheet
When I calculate the sum of numbers in the column G of a Microsoft Excel spreadsheet by using the formula =SUM(G1,G31) ,column G32 prints the date (0-Jan-00).
Is there any way in which the sum of ...
1
vote
5answers
2k views
Stop MS Excel 2003 closing all open workbooks
I have noticed that when I have multiple workbooks open with MS Excel and I close one, excel will attempt to close them all. This is extremely frustrating and has resulted in me losing work on many ...
1
vote
1answer
48 views
Having more spreadsheets displayed in the recent opened list in Excel 2003
I'm currently using Excel 2003. The list of recently opened spreadsheets accessed through the File menu contains the last four opened and edited spreadsheets.
Is it possible to change the number of ...
1
vote
3answers
5k views
Sharepoint List Exported to Excel - Columns are readonly
From a sharepoint list, I chose Actions -> Export to Spreadsheet, saved the owssvr.iqy file, opened this file, and tried editing entries in Excel.
When I try to edit any columns, I am shown: "The ...
4
votes
4answers
11k views
Select each nth row in Excel
I have an Excel spreadsheet with thousands of rows. I want to select every 7th row from that spreadsheet. (By "select," I mean delete all of the other rows, or copy the selected rows into a new ...
0
votes
1answer
112 views
excel function to count occurances of text in a column
please give me the complete code for me to copy and paste in order to get the results in column B. please note that my actual spreadsheet contains a lot more than just 3 different variables for ...
0
votes
1answer
132 views
Excel, deleted data recovery
How do I make sure that in Excel, if I delete some sensitive data and send the file around this is not recoverable?
0
votes
2answers
3k views
Macro to open excel hyperlinks
I would like to know if anyone can help me do a macro to open a list of hyper links.
I have a list of about 600 hyper links all in a column in separate rows, i have to open each one to see if the ...
0
votes
3answers
685 views
custom format for cells with nothing in them without using conditional formatting
if a cell is blank I would like to add text using a custom format. I've seen where text is added if a value is above or below a certain value. Can you add text to the cell if the cell is blank? I've ...
1
vote
2answers
1k views
Microsoft Excel Undo Only Works Twice
I am using Microsoft Excel 2003. A major irritant is that I am unable to use "undo" more than twice. Can you not use Undo more than 2 or 3 times or am I missing something? Are there any solutions to ...
0
votes
2answers
769 views
How to get Excel out of Select Cell mode
Looking for a tip on Microsoft Excel (2003):
If you click on a cell containing a formula, click into the formula, and click away, Excel will enter the cell or range you next select into the formula ...
6
votes
1answer
9k views
Hyperlink font in Excel always changes to the default font face/size
For cells containing hyperlinks the font changes automatically into the default one (even though I have selected all cells and applied a different font).
How can you configure Excel to use the same ...
1
vote
3answers
596 views
Excel select column
In excel, if I want to perform a function with the column to the left, how do I go about this?
1
vote
2answers
858 views
ASCII codes appear in Excel '03 but not '07
Part I - I have a spreadsheet that was from data exported from an application. When I open it, I can see the 'boxes' that usually are from a line break or paragraph break in a cell. IF I view the ...
