General

Edit with Microsoft Query - Menu Option
I installed Excel 2007 and now when I Right-Click on an existing Microsoft Query file(Excel 2000 or Excel 2003), I do not see the Menu Option to 'Edit with Microsoft Query". What am I missing? ... 12 May 2010 12:31

Copy or Move a spreadsheet
I recently converted to Office 2007 from Office 2003. I have multiple spreadsheets (or "work-books") that I develop for modeling things. Then in reports, I move single pages from different work-books into an "exhibits" spreadsheet (or workbook). When I try to do this in Excel 2007 I am always getting this p... 12 May 2010 15:53

Refresh some not Refresh All
Hello. I have a workbook with 10 sheets all of which have external data that needs to be refreshed periodically. Most of the time I only need to refresh 8 of the sheets. Is there a way to refresh just those 8 without having to refresh each one separately? Thanks in advance. ... 12 May 2010 13:38

Exception to password-protected document
Is it possible to password-protect the opening of a document for all users, EXCEPT one? Thanks ... 12 May 2010 12:31

Conditional formula
trying to construct a formula for the following for the same cell: if a2 > 6, then e2 = 0 if a2 = 6, then e2 = 1 if a2 = 5, then e2 = 2 if a2 = 4, then e2 = 3 if a2 = 3, then e2 =5 this is for a golf scoring system. a2 values are hole scores and results are "handicap" point scores. Any help greatly apprecia... 12 May 2010 12:31

Colours in Print preview?
Hi I have 16 pages in a workbook All of them have a few rows coloured for clarity. However, only one page shows the coloured rows in Print Preview. Why is that? -- Martin ���� ... 13 May 2010 06:07

Trying to save spreadsheet with macros???????
A co-worker sent me a form in Excel 2007 that I need to save, fill out, and return. I tried to save is with macros enabled but I keep getting a window with the message "This workbook contains Excel 4.0 macros or Excel 5.0 modules. If you would like to password protect or restrict permission to this document, ... 12 May 2010 10:16

Can you delete all asterisks in a sheet?
I have a spreadsheet with asterisks on certain entries. Is there any way to delete these? ... 13 May 2010 22:41

Binary Numbers
elegant! "Gary''s Student" wrote: In A1 enter: 11011011001110010101001110101011101011 as text in B1, enter: =LEN(A1)-LEN(SUBSTITUTE(A1,"1","")) to display 23 -- Gary''s Student - gsnu200828 "Sanford Lefkowitz" wrote: This might be more of a math question than... 12 May 2010 11:23

Need Macro to reset dependent list
Hi All, I have a set of 2 lists, one dependent on the other. If the value of the list in column A changes AFTER the value of the list in Column C is selected, I would like for column C to reset, or blank out. I know this can be done because I have seen it done before. It was code that was put into the sheet... 12 May 2010 13:38