1
Updating Excel formulas
I am using Excel 2007 on a Windows 7 system. Since I was upgraded to Windows 7, my formulas are not automatically updating when I copy and paste. My calculation settings are set to Automatic. Also, nothing happens when I press F9. The only way I can get the formula to provide the correct value [...]
Answer Question
| August 27, 2012 4:39 PM
Excel 2007 functions
I am using Excel 2007 on a Windows 7 system. Since I was upgraded to Windows 7, my formulas are not automatically updating when I copy and paste. My calculation settings are set to Automatic. Also, nothing happens when I press F9. The only way I can get the formula to provide the correct value [...]
Answer Question
| August 27, 2012 4:39 PM
Excel 2007 functions
Keep Text to Column format in Excel 2007
We’re wondering if there is a way to get Excel 2007 to remember the previous Text to Column settings. We are receiving reports in an email that we copy into Excel. We run the Text to Column>Delimited>Delimiters (Only Other = |)(Text Qualifier left as default = *)>Column Data Format (General). Every thing works great and [...]
Answer Question
| May 2, 2011 9:00 PM
Excel 2007, Excel 2007 functions, Excel functions
We’re wondering if there is a way to get Excel 2007 to remember the previous Text to Column settings. We are receiving reports in an email that we copy into Excel. We run the Text to Column>Delimited>Delimiters (Only Other = |)(Text Qualifier left as default = *)>Column Data Format (General). Every thing works great and [...]
Answer Question
| May 2, 2011 9:00 PM
Excel 2007, Excel 2007 functions, Excel functions
Create a macro in Excel 2007 to disable save
I need to create a macro in Excel 2007 to disable save
Answer Question
| March 11, 2011 6:01 AM
Excel 2007, Excel 2007 functions, Excel 2007 macros, Macros
I need to create a macro in Excel 2007 to disable save
Answer Question
| March 11, 2011 6:01 AM
Excel 2007, Excel 2007 functions, Excel 2007 macros, Macros
How to connect to quick 3270 secure screen through vba macro?
hi, i use the following code to connect to quick 3270 macro and it also connect to the screen.But when i run the macro for the first time it works ,but does not work when i run the same macro for second time.If i restart the mainframe then the macro runs. Below is the code. [...]
Answer Question
| February 2, 2011 5:44 AM
Excel 2007, Excel 2007 functions, Excel 2007 macros, VB script, VBA macro
hi, i use the following code to connect to quick 3270 macro and it also connect to the screen.But when i run the macro for the first time it works ,but does not work when i run the same macro for second time.If i restart the mainframe then the macro runs. Below is the code. [...]
Answer Question
| February 2, 2011 5:44 AM
Excel 2007, Excel 2007 functions, Excel 2007 macros, VB script, VBA macro
How to accept user input and display the value in Excel 2007 macros
I Created an Excel macro that prompts the user to enter two cell numbers. I want to then display a msgbox back showing the cells that were entered. Problem. My msgbox shows the text in my message and instead of showing the values the user entered, it shows ‘TRUE’. Any ideas?
Answer Question
| January 28, 2011 4:37 PM
Excel 2007, Excel 2007 functions, Excel 2007 macros, Excell 2007, Macros
I Created an Excel macro that prompts the user to enter two cell numbers. I want to then display a msgbox back showing the cells that were entered. Problem. My msgbox shows the text in my message and instead of showing the values the user entered, it shows ‘TRUE’. Any ideas?
Answer Question
| January 28, 2011 4:37 PM
Excel 2007, Excel 2007 functions, Excel 2007 macros, Excell 2007, Macros
Deleting successive rows on Excel 2007
Using VBA in a large timeline excel worksheet of 50000 rows. How can I automatically delete every 3 rows and leave the 4th row so I can reduce the number of rows to about 12,000.
Answer Question
| January 12, 2011 10:01 AM
Excel 2007, Excel 2007 functions, Excel 2007 workbooks, Excel worksheets
Using VBA in a large timeline excel worksheet of 50000 rows. How can I automatically delete every 3 rows and leave the 4th row so I can reduce the number of rows to about 12,000.
Answer Question
| January 12, 2011 10:01 AM
Excel 2007, Excel 2007 functions, Excel 2007 workbooks, Excel worksheets
Excel 2007 ‘Edit Links’ Command deleting information
I received a file from our corporate office. Some of the formulas in the workbook were referencing a location on a persons C:documents and settingsthatpersonmy documents. I wanted to change the reference to the existing file instead of the past months file it was looking at. I went into DataEdit Links highlighted the file I [...]
Answer Question
| March 11, 2011 5:58 PM
excel, Excel 2007, Excel 2007 functions, Excel 2007 workbooks, Outlook 2007
I received a file from our corporate office. Some of the formulas in the workbook were referencing a location on a persons C:documents and settingsthatpersonmy documents. I wanted to change the reference to the existing file instead of the past months file it was looking at. I went into DataEdit Links highlighted the file I [...]
Answer Question
| March 11, 2011 5:58 PM
excel, Excel 2007, Excel 2007 functions, Excel 2007 workbooks, Outlook 2007
Problem creating during hyperlink recall with Excel 2007
if am copying a folder in desk top that folder contains xl2007 sheets, in one of the sheet i was inserted some hyperlink for supporting folder.if am pasting this folder in desk top it may creating some problem means after opened the xls file am clicking the link that time file could not be found [...]
Answer Question
| November 23, 2010 7:00 AM
Excel 2007, Excel 2007 functions, Excel error messages, Hyperlinks
if am copying a folder in desk top that folder contains xl2007 sheets, in one of the sheet i was inserted some hyperlink for supporting folder.if am pasting this folder in desk top it may creating some problem means after opened the xls file am clicking the link that time file could not be found [...]
Answer Question
| November 23, 2010 7:00 AM
Excel 2007, Excel 2007 functions, Excel error messages, Hyperlinks
Search for column header in Excel 2007
I use a macro for a weekly report. In the macro i use “Column (“C:C”).Select to select that column to filter out the zeros. Sometimes the information is in a different column when the data is downloaded, but the header of the column is still the same: “90_day_Late”. How do i search for “90_day_Late” (say it [...]
Answer Question
| November 25, 2010 3:42 AM
Excel 2007, Excel 2007 functions, Excel 2007 macros, Excel functions, Excel macros
I use a macro for a weekly report. In the macro i use “Column (“C:C”).Select to select that column to filter out the zeros. Sometimes the information is in a different column when the data is downloaded, but the header of the column is still the same: “90_day_Late”. How do i search for “90_day_Late” (say it [...]
Answer Question
| November 25, 2010 3:42 AM
Excel 2007, Excel 2007 functions, Excel 2007 macros, Excel functions, Excel macros
Sending Excel 2007 spreadsheet without calculations
I want to save a copy of my spreadsheet to send to someone, without them seeing my calculations. I need to convert the equation, save the answers as they appear in number format. I know there is an easy step but can’t find the terms to search it properly. (Excel) Can someone please assist me?
Answer Question
| November 12, 2010 6:38 PM
Excel 2007, Excel 2007 functions, Excel 2007 workbooks, Excel functions
I want to save a copy of my spreadsheet to send to someone, without them seeing my calculations. I need to convert the equation, save the answers as they appear in number format. I know there is an easy step but can’t find the terms to search it properly. (Excel) Can someone please assist me?
Answer Question
| November 12, 2010 6:38 PM
Excel 2007, Excel 2007 functions, Excel 2007 workbooks, Excel functions
Unable to Refresh Pivot Table if Datasheet in Excel 2007 is not open.
I have several Pivot Tables linked to several like spreadsheets, respectively. When I refresh a Pivot, I get an error that excel is unable to open the file (that the table is linked to). If the file is open, I can refresh. My problem is each spread sheets contain huge amounts of data. Is there [...]
Answer Question
| November 8, 2010 7:41 PM
excel, Excel 2007, Excel 2007 functions, Excel 2007 workbooks, Pivot Table Refresh, Pivot tables
I have several Pivot Tables linked to several like spreadsheets, respectively. When I refresh a Pivot, I get an error that excel is unable to open the file (that the table is linked to). If the file is open, I can refresh. My problem is each spread sheets contain huge amounts of data. Is there [...]
Answer Question
| November 8, 2010 7:41 PM
excel, Excel 2007, Excel 2007 functions, Excel 2007 workbooks, Pivot Table Refresh, Pivot tables
Excel 2007 what is the command for scrolling down your rows with still seeing the header row at the top
I know this is so simple but what is the command for scrolling down through rows in Excel 2007 but still keeping the header (titles of the columns) in view. thanks so much!
Answer Question
| October 29, 2010 3:32 AM
COMMANDS, Excel 2007, Excel 2007 functions
I know this is so simple but what is the command for scrolling down through rows in Excel 2007 but still keeping the header (titles of the columns) in view. thanks so much!
Answer Question
| October 29, 2010 3:32 AM
COMMANDS, Excel 2007, Excel 2007 functions
Is there a standard formula for counting highlighted cells in Excel 2007?
Is there a formula for when you highlight some data cells, for use of simply counting rows, that Excel will give you the count of those cells as the answer on another sheet in the workbook- just by highlighting? But this is based on highlighting random cells in a column every day, never the same [...]
Answer Question
| June 6, 2012 3:20 AM
Excel 2007, Excel 2007 functions, Excel 2007 workbooks, Excel Database, Excel functions
Is there a formula for when you highlight some data cells, for use of simply counting rows, that Excel will give you the count of those cells as the answer on another sheet in the workbook- just by highlighting? But this is based on highlighting random cells in a column every day, never the same [...]
Answer Question
| June 6, 2012 3:20 AM
Excel 2007, Excel 2007 functions, Excel 2007 workbooks, Excel Database, Excel functions
How to collapse data in a Pivot Table in Excel 2007?
I created a Pivot Table and its giving me a description with the different codes that fall under each I want to collaspe all the descriptions so that the codes under each disappear and are summed up within each description I can do them one at a time but I have some many lines to [...]
Answer Question
| December 13, 2010 5:38 PM
Excel 2007, Excel 2007 functions, Excel 2007 workbooks, Excel Forms, Excel functions, PivotTable
I created a Pivot Table and its giving me a description with the different codes that fall under each I want to collaspe all the descriptions so that the codes under each disappear and are summed up within each description I can do them one at a time but I have some many lines to [...]
Answer Question
| December 13, 2010 5:38 PM
Excel 2007, Excel 2007 functions, Excel 2007 workbooks, Excel Forms, Excel functions, PivotTable
Tracking active Excel 2007 table updates
CAN I SEE THE ACTUAL CHANGES SOMEONE MAKES, ON A SECOND OPENING OF THE SAME WORKBOOK (SHEET) ON A DIFFERENT COMPUTER OR (DIFF MONITOR OF THE SAME USER). I WANT TO OPEN THE SAME WORKBOOK ON TWO DIFFERENT MONITORS (OR COMPUTERS) AND TRACK (SEE) THE CHANGES LIVE (OR NEAR LIVE) ON THE SECOND. THE SECOND CAN BE [...]
Answer Question
| October 22, 2010 6:52 AM
Excel 2003 to Excel 2007 Upgrade, Excel 2007, Excel 2007 functions, Excel worksheets, Windows 7
CAN I SEE THE ACTUAL CHANGES SOMEONE MAKES, ON A SECOND OPENING OF THE SAME WORKBOOK (SHEET) ON A DIFFERENT COMPUTER OR (DIFF MONITOR OF THE SAME USER). I WANT TO OPEN THE SAME WORKBOOK ON TWO DIFFERENT MONITORS (OR COMPUTERS) AND TRACK (SEE) THE CHANGES LIVE (OR NEAR LIVE) ON THE SECOND. THE SECOND CAN BE [...]
Answer Question
| October 22, 2010 6:52 AM
Excel 2003 to Excel 2007 Upgrade, Excel 2007, Excel 2007 functions, Excel worksheets, Windows 7
Graphing Challenge in Excel 2007
I am working on a project, and was wondering if there is a quicker/better/easier way to do it than what I have been doing. I have two sets of data – one for 2009 and one for 2010 – broken out by department (there are about 100 different departments with which I am working). The [...]
Answer Question
| October 19, 2010 9:25 PM
Excel 2007, Excel 2007 functions, Excel 2007 workbooks, Graphical User Interfaces
I am working on a project, and was wondering if there is a quicker/better/easier way to do it than what I have been doing. I have two sets of data – one for 2009 and one for 2010 – broken out by department (there are about 100 different departments with which I am working). The [...]
Answer Question
| October 19, 2010 9:25 PM
Excel 2007, Excel 2007 functions, Excel 2007 workbooks, Graphical User Interfaces
Adding “days” to a cell in Excel 2007
I have a list of # of days’ inventory for a product and wish to add “days” to each cell. For example, “29″ would appear as “29 days”, with the numerical value unchanged, so my formulas still work. How do I do this?
Answer Question
| January 19, 2012 4:37 AM
Excel 2007, Excel 2007 functions, Excel worksheets, Windows 7
I have a list of # of days’ inventory for a product and wish to add “days” to each cell. For example, “29″ would appear as “29 days”, with the numerical value unchanged, so my formulas still work. How do I do this?
Answer Question
| January 19, 2012 4:37 AM
Excel 2007, Excel 2007 functions, Excel worksheets, Windows 7
View row labels as column headings when scrolling in Excel 2007
Row 1 contains the column labels, when scrolling the A, B C column headings are replaced with the row names. It is not “freeze” situation.
Answer Question
| October 4, 2010 5:57 PM
Excel 2007, Excel 2007 functions, Excel 2007 workbooks, Excel functions
Row 1 contains the column labels, when scrolling the A, B C column headings are replaced with the row names. It is not “freeze” situation.
Answer Question
| October 4, 2010 5:57 PM
Excel 2007, Excel 2007 functions, Excel 2007 workbooks, Excel functions
Matching data in Excel
Hi, We have two sets of data in Excel that we need to match up and combine when they match. Spreadsheet 1 has two columns, A is a S/N and B is the page count. Spreadsheet 2 also has two columns, A is the S/N and column B is an ID number. We need to [...]
Answer Question
| September 28, 2010 8:15 PM
Excel 2007, Excel 2007 functions, Excel Database, Excel worksheets
Hi, We have two sets of data in Excel that we need to match up and combine when they match. Spreadsheet 1 has two columns, A is a S/N and B is the page count. Spreadsheet 2 also has two columns, A is the S/N and column B is an ID number. We need to [...]
Answer Question
| September 28, 2010 8:15 PM
Excel 2007, Excel 2007 functions, Excel Database, Excel worksheets
How do I disable save/save as and control +s and f12 in excel 2007?
I want o disable those and only allow save feature through the macro I established
Answer Question
| October 1, 2010 7:10 PM
Excel 2007, Excel 2007 functions, Excel functions, Office 2007
I want o disable those and only allow save feature through the macro I established
Answer Question
| October 1, 2010 7:10 PM
Excel 2007, Excel 2007 functions, Excel functions, Office 2007
1
