Download software
How can I download a program which only runs on Microsoft Excel 32 bit when my current operating system is running on Windows Home Premium 7 64bit?
Answer Question
| May 17, 2013 5:45 PM
Microsoft Excel, Windows Home Premium
How can I download a program which only runs on Microsoft Excel 32 bit when my current operating system is running on Windows Home Premium 7 64bit?
Answer Question
| May 17, 2013 5:45 PM
Microsoft Excel, Windows Home Premium
Filters
How do you remove the filter arrows from an Excel table?
Answer Question
| May 9, 2013 4:18 PM
Microsoft Excel, Microsoft Excel table
How do you remove the filter arrows from an Excel table?
Answer Question
| May 9, 2013 4:18 PM
Microsoft Excel, Microsoft Excel table
Excel
How do I find the sum in an Excel spreadsheet?
Answer Question
| May 6, 2013 11:55 PM
Microsoft Excel, Microsoft Excel formulas
How do I find the sum in an Excel spreadsheet?
Answer Question
| May 6, 2013 11:55 PM
Microsoft Excel, Microsoft Excel formulas
Sheet protection
My spreadsheet is “read only” accessed by others in my business. Certain columns are locked. I’d like users to be able to copy and insert new copied rows, but when the sheet is protected copy and insert copied rows is not allowed. How do I allow this when sheet is protected?
Answer Question
| April 16, 2013 2:28 AM
Microsoft Excel, Microsoft Excel permissions
My spreadsheet is “read only” accessed by others in my business. Certain columns are locked. I’d like users to be able to copy and insert new copied rows, but when the sheet is protected copy and insert copied rows is not allowed. How do I allow this when sheet is protected?
Answer Question
| April 16, 2013 2:28 AM
Microsoft Excel, Microsoft Excel permissions
Find and replace text in PPT
I have a project to find and replace words in PowerPoint from Excel and then save the PowerPoint. My code is working fine. But when PPT has mp3 then it giving errors. Please see the code and tell me what change I should do. Sub pptopen()Dim a AsIntegerFor a =2To4Dim pptApp As PowerPoint.Application Dim pptPres [...]
Answer Question
| April 11, 2013 11:00 AM
Microsoft Excel, Microsoft PowerPoint, VBA
I have a project to find and replace words in PowerPoint from Excel and then save the PowerPoint. My code is working fine. But when PPT has mp3 then it giving errors. Please see the code and tell me what change I should do. Sub pptopen()Dim a AsIntegerFor a =2To4Dim pptApp As PowerPoint.Application Dim pptPres [...]
Answer Question
| April 11, 2013 11:00 AM
Microsoft Excel, Microsoft PowerPoint, VBA
Creating tools to perform some actions
I need to check for blank lines occurred in Excel file, if so I need to filter and check the associated name then send them a reply to update for that blank line which is taking so much time so wants to automate this task. Kindly help.
Answer Question
| April 11, 2013 7:14 AM
Microsoft Excel, Microsoft Excel files
I need to check for blank lines occurred in Excel file, if so I need to filter and check the associated name then send them a reply to update for that blank line which is taking so much time so wants to automate this task. Kindly help.
Answer Question
| April 11, 2013 7:14 AM
Microsoft Excel, Microsoft Excel files
Productivity
Your team consists of 10 agents, each agent takes 18 calls per day and the average handling time for troubleshooting calls is 90 minutes and the average handling time for transfer calls is 6 minutes and 10 minutes for information calls. The floor averages on the of calls are as follows Troubleshooting calls 30% Transfer [...]
Answer Question
| April 10, 2013 3:39 AM
Microsoft Excel
Your team consists of 10 agents, each agent takes 18 calls per day and the average handling time for troubleshooting calls is 90 minutes and the average handling time for transfer calls is 6 minutes and 10 minutes for information calls. The floor averages on the of calls are as follows Troubleshooting calls 30% Transfer [...]
Answer Question
| April 10, 2013 3:39 AM
Microsoft Excel
Embedding linked Excel into PDF
Can an Excel file linked from a PDF be embedded in that PDF to deliver 1 file instead of 2? Alternatives?
Answer Question
| March 18, 2013 11:46 AM
Microsoft Excel, PDF
Can an Excel file linked from a PDF be embedded in that PDF to deliver 1 file instead of 2? Alternatives?
Answer Question
| March 18, 2013 11:46 AM
Microsoft Excel, PDF
User prompted for AS/400 log on when using Excel Add-in to upload data.
I have users that are uploading data to the AS/400 (V6R1) using the Excel Add-in. One user gets a log on pop up window each time she initiates the data transfer. Others in her same group do not. Where would I go to turn this off? She is logged on an AS/400 session and it [...]
Answer Question
| March 13, 2013 7:29 PM
AS/400, IBM Client Access, iSeries Navigator, Microsoft Excel
I have users that are uploading data to the AS/400 (V6R1) using the Excel Add-in. One user gets a log on pop up window each time she initiates the data transfer. Others in her same group do not. Where would I go to turn this off? She is logged on an AS/400 session and it [...]
Answer Question
| March 13, 2013 7:29 PM
AS/400, IBM Client Access, iSeries Navigator, Microsoft Excel
Excel 7
I have a large spreadsheet with cell that contain similar older catalog numbers. Want to update to the latest version of catalog number. Can I delete/ remove a character from the following Example: 23LB412 take out the “B” and keep the following: 23L412
Answer Question
| March 11, 2013 6:26 PM
Microsoft Excel, Microsoft Excel spreadsheet
I have a large spreadsheet with cell that contain similar older catalog numbers. Want to update to the latest version of catalog number. Can I delete/ remove a character from the following Example: 23LB412 take out the “B” and keep the following: 23L412
Answer Question
| March 11, 2013 6:26 PM
Microsoft Excel, Microsoft Excel spreadsheet
Number formats
I pasted a bank statement into Excel but I can’t successfully do any calculations. Can you help?
Answer Question
| March 4, 2013 3:30 PM
Microsoft Excel, Microsoft Excel formulas
I pasted a bank statement into Excel but I can’t successfully do any calculations. Can you help?
Answer Question
| March 4, 2013 3:30 PM
Microsoft Excel, Microsoft Excel formulas
Updating in realtime with MS Word and Excel
There are 1500 people checking in to a motel for a yearly convention. I am in charge of registration and as I mark person/people who checked in, I want four other laptops that are online with same OS and same Excel or Word (office 2007) loaded on page. I want all four computers to update [...]
Answer Question
| March 4, 2013 2:04 PM
Microsoft Excel, Microsoft Word
There are 1500 people checking in to a motel for a yearly convention. I am in charge of registration and as I mark person/people who checked in, I want four other laptops that are online with same OS and same Excel or Word (office 2007) loaded on page. I want all four computers to update [...]
Answer Question
| March 4, 2013 2:04 PM
Microsoft Excel, Microsoft Word
Claculate slope & Intercept from line drawn in chart (Excel)
Is there a way to compute the slope & intercept of a line (object) drawn on a chart in Excel using VBA? I have an X-Y chart with data and I want to have the flexibility of drawing my own “best-fit” line through the data. Thanks, Frank
Answer Question
| March 4, 2013 8:13 PM
Microsoft Excel, VBA
Is there a way to compute the slope & intercept of a line (object) drawn on a chart in Excel using VBA? I have an X-Y chart with data and I want to have the flexibility of drawing my own “best-fit” line through the data. Thanks, Frank
Answer Question
| March 4, 2013 8:13 PM
Microsoft Excel, VBA
Populate an Excel drop down list from ASP.NET using VB.NET
How do you populate an Excel spreadsheet that contains drop down list using ASP.NET with VB.NET code behind. I can easily populate or update the cells by name because the headers are not on the first row but when I am trying to populate a cell that has a drop down list attached to it, [...]
Answer Question
| February 28, 2013 8:30 PM
ASP.NET, Microsoft Excel, VB .NET
How do you populate an Excel spreadsheet that contains drop down list using ASP.NET with VB.NET code behind. I can easily populate or update the cells by name because the headers are not on the first row but when I am trying to populate a cell that has a drop down list attached to it, [...]
Answer Question
| February 28, 2013 8:30 PM
ASP.NET, Microsoft Excel, VB .NET
How to get weekly chart updates
In Excel macros I would like to change a reference cell incrementally each time I do a button click. How would I do that? For example start out referencing cell b6 then one button click reference cell b7 and so on as often as I push the button it would increase the cell reference to [...]
Answer Question
| February 28, 2013 8:25 PM
Microsoft Excel, Microsoft Excel macros
In Excel macros I would like to change a reference cell incrementally each time I do a button click. How would I do that? For example start out referencing cell b6 then one button click reference cell b7 and so on as often as I push the button it would increase the cell reference to [...]
Answer Question
| February 28, 2013 8:25 PM
Microsoft Excel, Microsoft Excel macros
Excel lookup and totals
Find specified values in one column, and total vaues in other columns of the specified value.
Answer Question
| February 20, 2013 12:11 PM
Microsoft Excel, microsoft excel functions
Find specified values in one column, and total vaues in other columns of the specified value.
Answer Question
| February 20, 2013 12:11 PM
Microsoft Excel, microsoft excel functions
Drop down menu’s in PDFs saved from Excel files
Is there any straightforward way to save an Excel file as a PDF while retaining the functionality of the drop down menus? I have a few drop downs that I’ve added to an excel file and I want to save this file as a PDF to the point that I can open the PDF and [...]
Answer Question
| February 14, 2013 11:20 PM
Microsoft Excel, PDF, VBA
Is there any straightforward way to save an Excel file as a PDF while retaining the functionality of the drop down menus? I have a few drop downs that I’ve added to an excel file and I want to save this file as a PDF to the point that I can open the PDF and [...]
Answer Question
| February 14, 2013 11:20 PM
Microsoft Excel, PDF, VBA
Objects embedded in Excel
I placed an object (PDF) in an Excel spreadsheet. When I go to minimize the row or filter the row/column’s the objects do not move. How do I get it so it stays within that row?
Answer Question
| February 11, 2013 12:54 PM
Microsoft Excel, Microsoft Excel spreadsheet, PDF
I placed an object (PDF) in an Excel spreadsheet. When I go to minimize the row or filter the row/column’s the objects do not move. How do I get it so it stays within that row?
Answer Question
| February 11, 2013 12:54 PM
Microsoft Excel, Microsoft Excel spreadsheet, PDF
How can I copy/paste a table from Excel to Lotus Notes
Hi all, I’ve been reading some posts about my question over the internet but didn’t find any accurate answer. Here’s the problem: When I click a button in Excel, i need the table from a certain “Range” to copy/paste in the body of an e-mail that will send itself automatically. Now, I know how to [...]
Answer Question
| February 4, 2013 4:11 PM
Lotus Notes, Microsoft Excel
Hi all, I’ve been reading some posts about my question over the internet but didn’t find any accurate answer. Here’s the problem: When I click a button in Excel, i need the table from a certain “Range” to copy/paste in the body of an e-mail that will send itself automatically. Now, I know how to [...]
Answer Question
| February 4, 2013 4:11 PM
Lotus Notes, Microsoft Excel
Excel conditional formula
Hi all, I can write a basic conditional formula such as =IF(A1=”23″, “OK”, “NOT OK”), but I want to add a supplementary condition … For example if A1 is 23 and B1is 24 then the cell will display OK or NOT OK as appropriate… both conditions need to be met. TIA, John
Answer Question
| February 1, 2013 8:46 AM
Microsoft Excel, Microsoft Excel formulas
Hi all, I can write a basic conditional formula such as =IF(A1=”23″, “OK”, “NOT OK”), but I want to add a supplementary condition … For example if A1 is 23 and B1is 24 then the cell will display OK or NOT OK as appropriate… both conditions need to be met. TIA, John
Answer Question
| February 1, 2013 8:46 AM
Microsoft Excel, Microsoft Excel formulas
