Conditional Formatting – Excel 2007
Greetings. I was on hiatus from this excellent forum for some time. Got involved in too many other tasks & was unable to free myself to devote time to this forum. Now, I am seeking help on how to extend Conditional Formatting rule. The scenario is this: I have a worksheet with about 200 rows. [...]
Answer Question
| October 21, 2010 7:19 AM
Conditional formatting, Excel 2007, Excel Formatting, EXTEND mode, Office 2007, Windows XP
Greetings. I was on hiatus from this excellent forum for some time. Got involved in too many other tasks & was unable to free myself to devote time to this forum. Now, I am seeking help on how to extend Conditional Formatting rule. The scenario is this: I have a worksheet with about 200 rows. [...]
Answer Question
| October 21, 2010 7:19 AM
Conditional formatting, Excel 2007, Excel Formatting, EXTEND mode, Office 2007, Windows XP
rows don’t line up or text does not appear with excel 2007
I have instances where the rows (left freeze panel) do not line up ( and right panel)!!! sometimes the text does not appear on the screen, OR looks like it writes over itself. Happens when i do a control f to find text usually but not all the time. Anyone else having this problem?
Answer Question
| November 10, 2010 6:12 PM
excel, Excel 2007, Excel 2007 workbooks
I have instances where the rows (left freeze panel) do not line up ( and right panel)!!! sometimes the text does not appear on the screen, OR looks like it writes over itself. Happens when i do a control f to find text usually but not all the time. Anyone else having this problem?
Answer Question
| November 10, 2010 6:12 PM
excel, Excel 2007, Excel 2007 workbooks
Multiple Names in Excel 2007
I have a Excel sheet with hundreds of names and the same person may be repeated twice How do I create a formula so that I can like it to a new sheet and it only show a persons name one time
Answer Question
| July 26, 2010 6:58 PM
excel, Excel 2007, Excel Forms, Excel formulas
I have a Excel sheet with hundreds of names and the same person may be repeated twice How do I create a formula so that I can like it to a new sheet and it only show a persons name one time
Answer Question
| July 26, 2010 6:58 PM
excel, Excel 2007, Excel Forms, Excel formulas
password remover for excel 2007
i have forgotten password for my imp excell sheet how would i can recover that excel sheet now
Answer Question
| July 28, 2010 4:14 AM
Application security, excel, Excel 2007, Microsoft Excel password protection
i have forgotten password for my imp excell sheet how would i can recover that excel sheet now
Answer Question
| July 28, 2010 4:14 AM
Application security, excel, Excel 2007, Microsoft Excel password protection
VBA Excel – paste not working
I have the following piece of code attached to my Excel worksheet: ActiveSheet.Shapes(“Object 407″).Select Selection.Copy Range(“BP106″).Select ActiveSheet.Paste The code is activated by making a choice in a drop down in the worksheet. The worksheet is password protected but the cell BP106 is not locked. When I make a selection from the [...]
Answer Question
| June 28, 2010 3:18 PM
Excel 2007, Excel VBA, VBA, Visual Basic for Applications
I have the following piece of code attached to my Excel worksheet: ActiveSheet.Shapes(“Object 407″).Select Selection.Copy Range(“BP106″).Select ActiveSheet.Paste The code is activated by making a choice in a drop down in the worksheet. The worksheet is password protected but the cell BP106 is not locked. When I make a selection from the [...]
Answer Question
| June 28, 2010 3:18 PM
Excel 2007, Excel VBA, VBA, Visual Basic for Applications
I wish to have my macro copy a cell from a tab, then go to another tab and search specifically for the value of the initial cell.
Hi. I wish to have my macro copy a cell from a tab, then go to another tab and search specifically for the value of the initial cell. i.e. the VB code should allow the “Cells.Find(What:=) to be VARIABLE based on what is pasted. Any suggestions?
Answer Question
| June 30, 2010 1:51 PM
Excel 2007, Excel 2007 macros, Excel functions, Excel VB code
Hi. I wish to have my macro copy a cell from a tab, then go to another tab and search specifically for the value of the initial cell. i.e. the VB code should allow the “Cells.Find(What:=) to be VARIABLE based on what is pasted. Any suggestions?
Answer Question
| June 30, 2010 1:51 PM
Excel 2007, Excel 2007 macros, Excel functions, Excel VB code
Excel limiting access
I want to be able to give access to a spreadsheet for a certain period of time, or until a specific date. Can this be done, and what is the most effective way?
Answer Question
| June 11, 2010 8:08 AM
Access control, Excel 2007, Windows XP
I want to be able to give access to a spreadsheet for a certain period of time, or until a specific date. Can this be done, and what is the most effective way?
Answer Question
| June 11, 2010 8:08 AM
Access control, Excel 2007, Windows XP
Embedding Microsoft Excel spreadsheet 2007 into Notes 6.5
My computer is running Notes 6.5 and Excel 2000. I have a request to display data in Microsoft Excel and for my computer it works fine. But when I try it on a laptop running Vista, Notes 7 & Microsoft 2007 the embedd statement doesn’t work. I have it coded as: Set object = rtitem.EmbedObjet(EMBED_OBJECT, [...]
Answer Question
| May 26, 2010 5:20 PM
Embedded programming, Excel 2007, Lotus Notes 6.5
My computer is running Notes 6.5 and Excel 2000. I have a request to display data in Microsoft Excel and for my computer it works fine. But when I try it on a laptop running Vista, Notes 7 & Microsoft 2007 the embedd statement doesn’t work. I have it coded as: Set object = rtitem.EmbedObjet(EMBED_OBJECT, [...]
Answer Question
| May 26, 2010 5:20 PM
Embedded programming, Excel 2007, Lotus Notes 6.5
Excel Macro
I created a macro and it is saved in personal.xls. How can I make this macro available to other users? I want to be able to give them the ability to run the macro – they do not need to modify it.
Answer Question
| May 25, 2010 12:11 PM
Excel 2007, Microsoft Excel macros, User access, XLS
I created a macro and it is saved in personal.xls. How can I make this macro available to other users? I want to be able to give them the ability to run the macro – they do not need to modify it.
Answer Question
| May 25, 2010 12:11 PM
Excel 2007, Microsoft Excel macros, User access, XLS
Converting Lotus Approach files to Excel 2007
I received a Lotus Approach 97 .APR file extension file on a flash drive. I need to import it into Excel (Microsoft Office 2007). I am a beginner with Excel and I need to know the steps required to import the Lotus Approach 97 file on the Flash Drive to Excel. I would appreciate any [...]
Answer Question
| May 20, 2010 1:36 PM
Excel 2007, File conversion, Flash drive, Lotus Approach, Office 2007
I received a Lotus Approach 97 .APR file extension file on a flash drive. I need to import it into Excel (Microsoft Office 2007). I am a beginner with Excel and I need to know the steps required to import the Lotus Approach 97 file on the Flash Drive to Excel. I would appreciate any [...]
Answer Question
| May 20, 2010 1:36 PM
Excel 2007, File conversion, Flash drive, Lotus Approach, Office 2007
Enter key does not get translated when doing a mail merge into word from excel
We are using Mail merge to automate status report generation for our projects. The data source is excel 2007 spreadsheet. The merge field in excel has multiple lines concatenated with a enter key coded as Char(13) in excel. In some places this key gets translated as _x000D_ in word. This happens only in a few [...]
Answer Question
| May 17, 2010 4:24 PM
Excel 2007, Microsoft Excel Mail Merge, Office 2007, Windows 7
We are using Mail merge to automate status report generation for our projects. The data source is excel 2007 spreadsheet. The merge field in excel has multiple lines concatenated with a enter key coded as Char(13) in excel. In some places this key gets translated as _x000D_ in word. This happens only in a few [...]
Answer Question
| May 17, 2010 4:24 PM
Excel 2007, Microsoft Excel Mail Merge, Office 2007, Windows 7
How do I associate an employee # to a name in Excel 2007?
I work in a restaurant and created a tip out spreadsheet. I need to insert employee names constantly. It would be much easier to just type in their employee# and have their name appear in another cell. Ex: Column A=Employee#, Column B=Employee’s name. I want to type in the employee’s # in cell A1 and [...]
Answer Question
| April 24, 2010 2:44 PM
excel, Excel 2007, Excel 2007 workbooks, Excel formulas, Microsoft Excel 2007
I work in a restaurant and created a tip out spreadsheet. I need to insert employee names constantly. It would be much easier to just type in their employee# and have their name appear in another cell. Ex: Column A=Employee#, Column B=Employee’s name. I want to type in the employee’s # in cell A1 and [...]
Answer Question
| April 24, 2010 2:44 PM
excel, Excel 2007, Excel 2007 workbooks, Excel formulas, Microsoft Excel 2007
How do you calculate formulas in Excel 2007?
I am new to Excel and have a project to do tomorrow at my new position. We have contracts that start on a certain date in 2010 and will bill for various time periods. For example, we received a 240,000contract and will bill for the remainder of 2010 at $10,000 per month. The total for [...]
Answer Question
| November 9, 2012 1:16 AM
Excel 2007, Excel formulas
I am new to Excel and have a project to do tomorrow at my new position. We have contracts that start on a certain date in 2010 and will bill for various time periods. For example, we received a 240,000contract and will bill for the remainder of 2010 at $10,000 per month. The total for [...]
Answer Question
| November 9, 2012 1:16 AM
Excel 2007, Excel formulas
excel 2007 chart automation
hi, I have a code that copy charts from one sheet to another sheet and plot graphs. But when I run multiple instances of excel simultaneously sometimes it copy all graphs and sometimes 2 ,4 or 6 charts. This application is working fine with EXCEL 2003 but with EXCEL 2007 giving above problem. please help me [...]
Answer Question
| April 6, 2010 1:53 PM
Excel 2007, Microsoft Excel 2007 charts
hi, I have a code that copy charts from one sheet to another sheet and plot graphs. But when I run multiple instances of excel simultaneously sometimes it copy all graphs and sometimes 2 ,4 or 6 charts. This application is working fine with EXCEL 2003 but with EXCEL 2007 giving above problem. please help me [...]
Answer Question
| April 6, 2010 1:53 PM
Excel 2007, Microsoft Excel 2007 charts
What formula is needed for this below in Excel?
What Excel Formula’s could i use? First # is starts with 1 back slash 2400. 2400 stays the same only first # changes. example below: [table style="border-collapse: collapse; width: 65pt;" border="0" cellpadding="0" cellspacing="0" width="86"> [col style="width: 65pt;" width="86">[/cOLIST] [tbody] [tr style="height: 12.75pt;" height="17"> [td class="xl66" style="height: 12.75pt; width: 65pt;" height="17" width="86">1/2400[/td] [/tr] [tr style="height: 12.75pt;" [...]
Answer Question
| April 7, 2010 9:01 PM
Excel 2003, Excel 2007, Microsoft Excel
What Excel Formula’s could i use? First # is starts with 1 back slash 2400. 2400 stays the same only first # changes. example below: [table style="border-collapse: collapse; width: 65pt;" border="0" cellpadding="0" cellspacing="0" width="86"> [col style="width: 65pt;" width="86">[/cOLIST] [tbody] [tr style="height: 12.75pt;" height="17"> [td class="xl66" style="height: 12.75pt; width: 65pt;" height="17" width="86">1/2400[/td] [/tr] [tr style="height: 12.75pt;" [...]
Answer Question
| April 7, 2010 9:01 PM
Excel 2003, Excel 2007, Microsoft Excel
Filter & sort data tables in excel 2007
When I create a table in excel with data from an external data source using MS query, the resultant excel table doesn’t allow me to filter or sort the data (the menu options are greyed out) If I add columns with formulae to the right of my data table, it seems to view the two [...]
Answer Question
| April 26, 2010 12:59 PM
Data Tables, Excel 2007, filter, MS Query
When I create a table in excel with data from an external data source using MS query, the resultant excel table doesn’t allow me to filter or sort the data (the menu options are greyed out) If I add columns with formulae to the right of my data table, it seems to view the two [...]
Answer Question
| April 26, 2010 12:59 PM
Data Tables, Excel 2007, filter, MS Query
How to I create a Chart in Excel 2007 from Non Numerical Data?
We have several projects going at work and my boss is tired of sorting through Spreadsheets and told me to graph everything. I need to figure out how to make a chart register how many of word/phrase A, B, C etc. there are in a column and stick that in a graph. If anyone could [...]
Answer Question
| March 9, 2010 9:15 PM
Charts, Excel 2007, help
We have several projects going at work and my boss is tired of sorting through Spreadsheets and told me to graph everything. I need to figure out how to make a chart register how many of word/phrase A, B, C etc. there are in a column and stick that in a graph. If anyone could [...]
Answer Question
| March 9, 2010 9:15 PM
Charts, Excel 2007, help
Matching Items in 2 worksheets
This is probably incredibly basic and has a simple answer – at least I hope it does. I am using Excel 2007. I have 2 worksheets run from 2 different systems. The systems are supposed to have the exact same information, but unfortunately Sheet A has 1350 results and Sheet B has 1365 results. I am trying [...]
Answer Question
| March 8, 2010 10:51 PM
Excel 2007, Excel 2007 workbooks
This is probably incredibly basic and has a simple answer – at least I hope it does. I am using Excel 2007. I have 2 worksheets run from 2 different systems. The systems are supposed to have the exact same information, but unfortunately Sheet A has 1350 results and Sheet B has 1365 results. I am trying [...]
Answer Question
| March 8, 2010 10:51 PM
Excel 2007, Excel 2007 workbooks
Transfer particular pieces of data from Excel into Word over a large number of documents
Thank you for coming and reading my question! I am trying to write a letter in Microsoft Word 2007 that will be personalized with the names and addresses of about one thousand donors to a non-profit organization. I have a spreadsheet containing everyone’s name and address in Microsoft Excel 2007, and would like to be [...]
Answer Question
| March 5, 2010 7:12 PM
Excel 2007, Microsoft Excel, Microsoft Word, Word 2007
Thank you for coming and reading my question! I am trying to write a letter in Microsoft Word 2007 that will be personalized with the names and addresses of about one thousand donors to a non-profit organization. I have a spreadsheet containing everyone’s name and address in Microsoft Excel 2007, and would like to be [...]
Answer Question
| March 5, 2010 7:12 PM
Excel 2007, Microsoft Excel, Microsoft Word, Word 2007
How do I save as XLAM Excel add-in
I have some code that I want to use in Excel as an add-in. I have Excel 2007 and VB Express 2008 installed on XP Pro SP3. I see everyone saying to “save as XLAM Excel add-in” on forums and sties, but can’t find that option anywhere on my apps. What am I missing?
Answer Question
| May 8, 2013 8:41 PM
Add-in, Excel 2007, Visual Basic
I have some code that I want to use in Excel as an add-in. I have Excel 2007 and VB Express 2008 installed on XP Pro SP3. I see everyone saying to “save as XLAM Excel add-in” on forums and sties, but can’t find that option anywhere on my apps. What am I missing?
Answer Question
| May 8, 2013 8:41 PM
Add-in, Excel 2007, Visual Basic
