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 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 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 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
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
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
Woring on an excel 07 spread sheet. I would like a code that disables printing and saveing until all required cells are completed/filled out and clears the cells after printing. Any ideas
Answer Question | October 21, 2010 7:39 PM
Excel 2007, Excel VB code, Office 2007, Windows XP Pro SP3
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
When working in Excel 2007 Compatability Mode (XP, 2003 Office) when i go to cut, copy past the data into another spread sheet it pops into Picture Mode and locks up the data. If I put the data into 2007 and then cut, copy, paste it is editable and I can work with the data. [...]
Answer Question | November 19, 2010 6:20 PM
Excel 2007, Microsoft Office, Microsoft Online Services, Office 2003, Picture Box Class, Picture Mode, Windows XP
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
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
How do we transfer/export data with over 575,000 rows in Microsoft Access 2007 to Microsoft Excel 2007? Is there a way to change the export data # of rows restriction of 65,xxx rows to 1 million rows in Microsoft Access 2007?
Answer Question | February 17, 2011 5:19 PM
Access 2007, Data transfer, Data Transfer Function, Excel 2007, Excel Database
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
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
In Excel 2007: How to make current time/date (static) populate active cell when command button is clicked?
Answer Question | October 14, 2010 7:41 PM
Excel 2007, Excel 2007 macros, Excel macros, Office 2007, VBA, Visual Basic
How can I e-mail data, to be viewed in Excel, from a programme written in VB6, so that when the recipient opens it, the Excel workbook shows not only the data, but copies all the formulae, eg. Totalling columns etc. and the formatting, eg. colours?
Answer Question | September 17, 2010 4:36 PM
Excel 2007, Excel 2007 workbooks, VB 6.0, VB6, Visual Basic 6.0
We have a user who was working on a file for a long period of time when the power went out. She had not saved it recently but shouldn’t we be able to grab a temp file? Excel 2007 on a Windows 7 laptop. 64 bit.
Answer Question | September 16, 2010 4:59 PM
Excel 2007, Temporary files, Windows, Windows 7, Windows 7 64-bit
I have an excel spread sheet created via Crystal Reports export as a data only 2000-2003 excel (xls). Within this spread sheet are cells containing formulas with R1C1 referencing. When I open the spread sheet, the formulas are not calculated. I have changed cell referencing to R1C1 via the Office button, formula options, but the [...]
Answer Question | September 28, 2010 5:10 PM
Crystal Reports, Crystal Reports Export to Excel, excel, Excel 2000, Excel 2003, Excel 2007, Spreadsheet functions
dear sir/madam i have a table such as the left table and want to extract a table like the right one please give me the proper macro. best regards. hamid [table style="border-collapse: collapse; width: 300pt;" border="0" cellpadding="0" cellspacing="0" width="400"> [col style="width: 63pt;" width="84">[/cOLIST] [col style="width: 62pt;" width="83">[/cOLIST] [col style="width: 48pt;" width="64">[/cOLIST] [col style="width: 66pt;" width="88">[/cOLIST] [...]
Answer Question | August 25, 2010 7:30 AM
excel, Excel 2007, Excel 2007 macros, Excel macros, Excel Tables
Why are my Word and Excel documents automatically zipping in Microsoft 2007? When I save a document, is there a specific way to name them that will prevent this?
Answer Question | November 25, 2010 5:38 PM
excel, Excel 2007, Office 2007, Word 2007, Zip Files