Excel custom format, weekday & date line break query….
I created a spreadsheet which is to act as a rota, with the day and date displayed to the left. I entered the date then went to the custom format tab and entered dddd dd/mm/yyyy so it would display the day and date. So it can be printed with all the relevant data it is [...]
Answer Question
| April 16, 2009 4:34 PM
Excel 2003, Excel formulas, Excel functions, Microsoft Excel
I created a spreadsheet which is to act as a rota, with the day and date displayed to the left. I entered the date then went to the custom format tab and entered dddd dd/mm/yyyy so it would display the day and date. So it can be printed with all the relevant data it is [...]
Answer Question
| April 16, 2009 4:34 PM
Excel 2003, Excel formulas, Excel functions, Microsoft Excel
Excel file problem in Lotus Notes
When the user is trying to open an attachment ms excel 2003 file, the user is not able to open it, but the user is able to open the file after it is saved to the computer/ The user is having problem only witht he excel files.Can anyone please help me with this?
Answer Question
| April 9, 2009 7:59 AM
Excel 2003, Lotus Notes, Lotus Notes email, Lotus Notes email attachments, Microsoft Excel, Microsoft Excel 2003
When the user is trying to open an attachment ms excel 2003 file, the user is not able to open it, but the user is able to open the file after it is saved to the computer/ The user is having problem only witht he excel files.Can anyone please help me with this?
Answer Question
| April 9, 2009 7:59 AM
Excel 2003, Lotus Notes, Lotus Notes email, Lotus Notes email attachments, Microsoft Excel, Microsoft Excel 2003
How to assign a numerical value to a word in Excel
I want to be able to select a material from a drop down list in column A, then type in the time in Column B and in a third column have the cost appear. What I need is to associate eg. VHS as having a rate card of £30. I can make lists and I [...]
Answer Question
| May 9, 2013 10:57 AM
Excel 2003, Excel macros, Microsoft Excel
I want to be able to select a material from a drop down list in column A, then type in the time in Column B and in a third column have the cost appear. What I need is to associate eg. VHS as having a rate card of £30. I can make lists and I [...]
Answer Question
| May 9, 2013 10:57 AM
Excel 2003, Excel macros, Microsoft Excel
Excel 2003 toolbar functions greyed out, but not Excel 2007
I bought a new laptop which has a trial version of Office 2007. I have been using Office 2003 on this macjhine for a few weeks, & suddenly both excel 2003 & word 2003 have most functions greyed out, and excel and word are unusable. Excel & Word 2007 work fine (no protection is on). [...]
Answer Question
| April 2, 2009 6:26 PM
Excel 2003, Excel 2007, Excel Toolbars, Microsoft Excel
I bought a new laptop which has a trial version of Office 2007. I have been using Office 2003 on this macjhine for a few weeks, & suddenly both excel 2003 & word 2003 have most functions greyed out, and excel and word are unusable. Excel & Word 2007 work fine (no protection is on). [...]
Answer Question
| April 2, 2009 6:26 PM
Excel 2003, Excel 2007, Excel Toolbars, Microsoft Excel
VBA – selecting middle portion of a string
I’m having trouble pulling the middle portion out of a dynamic string. Ex: Orginal String 1 = John Doe, Age 35 (asd) Original String 2 = Tom Thompson, Age 100 (jkl) I need the code to produce… New String 1 = 35 New String 2 = 100 I’ve tried to research this, but am new [...]
Answer Question
| March 31, 2009 10:14 PM
Excel 2003, Microsoft Excel 2003, String manipulation, VBA, Visual Basic for Applications
I’m having trouble pulling the middle portion out of a dynamic string. Ex: Orginal String 1 = John Doe, Age 35 (asd) Original String 2 = Tom Thompson, Age 100 (jkl) I need the code to produce… New String 1 = 35 New String 2 = 100 I’ve tried to research this, but am new [...]
Answer Question
| March 31, 2009 10:14 PM
Excel 2003, Microsoft Excel 2003, String manipulation, VBA, Visual Basic for Applications
Problems using VLOOKUP
I have an excel 2003 spreadsheet that contains a Volunteer Worksheet for the purpose of driving clients to doctors offices, and another Transportaion Worksheet that enters the dates and medical facilities to where clients will to be driven. I am utilizing a form, with a drop down list, to find a volunteer and another dropdown [...]
Answer Question
| April 2, 2009 2:56 PM
Excel 2003, Excel functions, Microsoft Excel, VLOOKUP, VLOOKUP function
I have an excel 2003 spreadsheet that contains a Volunteer Worksheet for the purpose of driving clients to doctors offices, and another Transportaion Worksheet that enters the dates and medical facilities to where clients will to be driven. I am utilizing a form, with a drop down list, to find a volunteer and another dropdown [...]
Answer Question
| April 2, 2009 2:56 PM
Excel 2003, Excel functions, Microsoft Excel, VLOOKUP, VLOOKUP function
Excel 2003 docs now won’t open in Excel 2007
I created som docs using Excel 2003. New computer has Excel 2007 installed and now when I open the docs they are unreadable. Any help would be appreciated.
Answer Question
| December 29, 2011 10:56 PM
Excel 2003, Excel 2007, Legacy applications, Microsoft Excel import/export
I created som docs using Excel 2003. New computer has Excel 2007 installed and now when I open the docs they are unreadable. Any help would be appreciated.
Answer Question
| December 29, 2011 10:56 PM
Excel 2003, Excel 2007, Legacy applications, Microsoft Excel import/export
Excel 2003 – Conditional Formatting, please help a girl out :)
Hi, I am working with a tracking schedule for my job, and I am trying to impliment conidtional formatting into it, but some of it it just not working for me. I am working with Microsoft Excel 2003 and I was wondering if you could help me with my problem. Column B = Start Date [...]
Answer Question
| March 9, 2009 9:27 PM
Conditional Formtting, Excel 2003, Microsoft Excel
Hi, I am working with a tracking schedule for my job, and I am trying to impliment conidtional formatting into it, but some of it it just not working for me. I am working with Microsoft Excel 2003 and I was wondering if you could help me with my problem. Column B = Start Date [...]
Answer Question
| March 9, 2009 9:27 PM
Conditional Formtting, Excel 2003, Microsoft Excel
Excel 2003 – Conditional Formatting, please help me :)
Hi, I am working with a tracking schedule for my job, and I am trying to impliment conidtional formatting into it, but some of it it just not working for me. I am working with Microsoft Excel 2003 and I was wondering if you could help me with my problem. Column B = Start Date [...]
Answer Question
| March 2, 2009 4:51 PM
Conditional Formtting, Excel 2003, Microsoft Excel
Hi, I am working with a tracking schedule for my job, and I am trying to impliment conidtional formatting into it, but some of it it just not working for me. I am working with Microsoft Excel 2003 and I was wondering if you could help me with my problem. Column B = Start Date [...]
Answer Question
| March 2, 2009 4:51 PM
Conditional Formtting, Excel 2003, Microsoft Excel
Excel 2003 VBA drop down list and discontinuous ranges
I am attempting to populate a drop down list in excel using data validation and data contained in two discontinuous ranges. I have used the Union command in vba to create a named list which seems to correctly concatenate the two data ranges but when I validate the cell which is to contain the drop [...]
Answer Question
| February 27, 2009 3:43 PM
Excel 2003, Excel 2007, Microsoft Excel, VBA, VBA EXCEL 2003
I am attempting to populate a drop down list in excel using data validation and data contained in two discontinuous ranges. I have used the Union command in vba to create a named list which seems to correctly concatenate the two data ranges but when I validate the cell which is to contain the drop [...]
Answer Question
| February 27, 2009 3:43 PM
Excel 2003, Excel 2007, Microsoft Excel, VBA, VBA EXCEL 2003
Linking a checkbox to another checkbox – Excel 2003
In Excel 2003, I have a spreadsheet with multiple sheets (including a detailed page and summary page). Each sheet has about 20 subjects that contain YES / NO / N/A answer checkboxes. I need to be able to link corresponding summary and detailed checkbox’s with each other. EXP: When you check the detailed checkbox for [...]
Answer Question
| February 26, 2009 8:08 PM
Excel 2003, Excel macros, Microsoft Excel
In Excel 2003, I have a spreadsheet with multiple sheets (including a detailed page and summary page). Each sheet has about 20 subjects that contain YES / NO / N/A answer checkboxes. I need to be able to link corresponding summary and detailed checkbox’s with each other. EXP: When you check the detailed checkbox for [...]
Answer Question
| February 26, 2009 8:08 PM
Excel 2003, Excel macros, Microsoft Excel
Excel 2003 – conditional formatting
Hi, I am working with a tracking schedule for my job, and I am trying to impliment conidtional formatting into it, but some of it it just not working for me. I am working with Microsoft Excel 2003 and I was wondering if you could help me with my problem. Column B = Start Date [...]
Answer Question
| February 26, 2009 1:30 PM
Conditional formatting, Excel 2003, Microsoft Excel
Hi, I am working with a tracking schedule for my job, and I am trying to impliment conidtional formatting into it, but some of it it just not working for me. I am working with Microsoft Excel 2003 and I was wondering if you could help me with my problem. Column B = Start Date [...]
Answer Question
| February 26, 2009 1:30 PM
Conditional formatting, Excel 2003, Microsoft Excel
Sparklines in Word or Excel
Has anyone ever used sparklines in Word or Excel (both Office 2003 versions? What tool(s) did you use? What did you find best to use to summarize large numbers of data points (>25,000)? Thanks for the assistance.
Answer Question
| February 26, 2009 8:12 PM
Excel 2003, Microsoft Excel, Microsoft Word, Office 2003, Sparklines, Word 2003
Has anyone ever used sparklines in Word or Excel (both Office 2003 versions? What tool(s) did you use? What did you find best to use to summarize large numbers of data points (>25,000)? Thanks for the assistance.
Answer Question
| February 26, 2009 8:12 PM
Excel 2003, Microsoft Excel, Microsoft Word, Office 2003, Sparklines, Word 2003
Excel 2003 – Conditional Formtting Help
Hi, I am working with a tracking schedule for my job, and I am trying to impliment conidtional formatting into it, but some of it it just not working for me. I am working with Microsoft Excel 2003 and I was wondering if you could help me with my problem. Column B = Start Date [...]
Answer Question
| February 23, 2009 7:25 PM
Conditional formatting, Excel 2003, Microsoft Excel
Hi, I am working with a tracking schedule for my job, and I am trying to impliment conidtional formatting into it, but some of it it just not working for me. I am working with Microsoft Excel 2003 and I was wondering if you could help me with my problem. Column B = Start Date [...]
Answer Question
| February 23, 2009 7:25 PM
Conditional formatting, Excel 2003, Microsoft Excel
Excel question
I have made some forms to use as proposals to sent to customers. I want to be able to send these as a document and not a spreadsheet. I need the formulas in the spreadsheet however to complete the proposal on my end. The pages print ok but I don’t want to send an entire [...]
Answer Question
| February 16, 2009 6:25 PM
Excel 2003, Excel Forms, Microsoft Excel
I have made some forms to use as proposals to sent to customers. I want to be able to send these as a document and not a spreadsheet. I need the formulas in the spreadsheet however to complete the proposal on my end. The pages print ok but I don’t want to send an entire [...]
Answer Question
| February 16, 2009 6:25 PM
Excel 2003, Excel Forms, Microsoft Excel
Conditional Formatting Excel 2003
I have three columns, Column 1 = Start Date Column 2 = End Date Column 3 = Close Date I need to place a conditional format or and “IF” statement on columns 2 and 3. Stating if column 2 is after or 1 month from today’s date highlight in RED. And column 3 should state [...]
Answer Question
| February 20, 2009 5:26 PM
Conditional formatting, Excel 2003, Microsoft Excel
I have three columns, Column 1 = Start Date Column 2 = End Date Column 3 = Close Date I need to place a conditional format or and “IF” statement on columns 2 and 3. Stating if column 2 is after or 1 month from today’s date highlight in RED. And column 3 should state [...]
Answer Question
| February 20, 2009 5:26 PM
Conditional formatting, Excel 2003, Microsoft Excel
Predefine a named range for an exported SQL Server Reporting Services report
How can you predefine a named range for an SQL Server Reporting Services report exported to Excel? In particular, the named range must have a specific name, along with referring to a set of cells with specific columns for all rows rendered for the given table control. I am running SQL Server 2005 SP3 with [...]
Answer Question
| February 11, 2009 9:05 PM
Excel 2003, Microsoft Excel, Microsoft Excel 2003, SQL Server Reporting Services, SSRS
How can you predefine a named range for an SQL Server Reporting Services report exported to Excel? In particular, the named range must have a specific name, along with referring to a set of cells with specific columns for all rows rendered for the given table control. I am running SQL Server 2005 SP3 with [...]
Answer Question
| February 11, 2009 9:05 PM
Excel 2003, Microsoft Excel, Microsoft Excel 2003, SQL Server Reporting Services, SSRS
Conditional Formatting – Excel 2003
Hello, I would like to know how to setup a conditional format for the following example. Ex. Column 1: Company Column 2: Begin Date Column 3: End Date Column 4: Exceed Date if >3 (Calculates Column 2 & 3 in Days) Conditional Format for Column 4: if days exceeded 3 and “eguals the company in [...]
Answer Question
| February 10, 2009 8:20 PM
Conditional formatting, Excel 2003, Excel Formatting, Microsoft Excel
Hello, I would like to know how to setup a conditional format for the following example. Ex. Column 1: Company Column 2: Begin Date Column 3: End Date Column 4: Exceed Date if >3 (Calculates Column 2 & 3 in Days) Conditional Format for Column 4: if days exceeded 3 and “eguals the company in [...]
Answer Question
| February 10, 2009 8:20 PM
Conditional formatting, Excel 2003, Excel Formatting, Microsoft Excel
Using Excel 2003: Adding days to a cell that contains both a text and numeric entry.
Can a formula be written that allows days to be added to a cell that contains both text and numeric information? For example, Cell A1 has NAME 1/3/09. I want to add 30 day increments to the 1/3/09 date in adjacent cells. Can it be done? If so. how? Thanks.
Answer Question
| February 5, 2009 7:37 PM
Excel 2003, Excel Formatting, Excel formulas, Microsoft Excel
Can a formula be written that allows days to be added to a cell that contains both text and numeric information? For example, Cell A1 has NAME 1/3/09. I want to add 30 day increments to the 1/3/09 date in adjacent cells. Can it be done? If so. how? Thanks.
Answer Question
| February 5, 2009 7:37 PM
Excel 2003, Excel Formatting, Excel formulas, Microsoft Excel
Excel 2003 – who has shared document open?
If person #1 is editting a workbook and person #2 tries to open it, person #2 will be notified that the document is in use and asked if they want to open it ‘read only’. Is there a way to identify ‘who’ has the document open?
Answer Question
| February 5, 2009 7:50 PM
Excel 2003, Microsoft Excel
If person #1 is editting a workbook and person #2 tries to open it, person #2 will be notified that the document is in use and asked if they want to open it ‘read only’. Is there a way to identify ‘who’ has the document open?
Answer Question
| February 5, 2009 7:50 PM
Excel 2003, Microsoft Excel
