General

How can I regain control of a shared spreadsheet
Hi - I have an Excel spreadsheet that is saved on the network and accessed by several users. For two days now we cannot edit the document because it says it is in use by "domainname". It doesn't give an actual user so I think it is hung up somehow. How can I regain control of this document? Thanks! Micha... 18 Mar 2010 10:33

Conditional Format help
Hi I have a date in H4 where using conditional formatting, will flag green if its within 2 days of today, amber if 2-3 days of today and red if 3+ days from today however, i need the formatting to stop if there has been a date entered into I4 (as this will mean there is no need for the cell to flag to us that ... 18 Mar 2010 10:33

Saving collected data?
Hi Everyone, I am compiling a table/worksheet that collects date related numerical information from another worksheet. ie: The table collecting the info is just columns of dates for a year with adjacent columns for data collection. The worksheet supplying the info has new information entered every day und... 18 Mar 2010 13:01

ODBC Driver Manager: Option type out of range
I Also have the same problem. Did any one of you find a solution? Microsoft wont help me because it is still in Beta release! Thanks. ... 13 Apr 2010 12:50

How do I get a total
A1 through A9 Has part numbers B1 through B9 has price C1 through c9 has quanitys required to make a set D1 gives total Price of set A1 part#1 B1 $65.00 c1 requires 3 for a set D1 total price -- Thanks Mike ... 18 Mar 2010 10:33

Advanced Filtering
Hi – are there any Excel guru's out there who can help me with advanced filtering? I need to find rows that 'contain' the value in my criteria range not that 'equal' it….does anyone know if this can be done? ... 18 Mar 2010 02:40

How to see full path name of open workbook?
Is there a simple way to see the full path name (folder and file name) of an open workbook? ... 21 Mar 2010 17:22

How do I automatically hide columns?
"PPM at Brackmills" wrote: I have a table with dates as the top row. I want Excel to find todays date and then hide the columns after todays date. In this way I can make the printed output bigger and more readable. ... 18 Mar 2010 00:30

How to change color within string?
Does anyone have any suggestions on how to change color within string? For example, in cell B1, if(A1=1,"O-F-O-F","O-N-O-N"), I would like to the last 3 chars into red color, such as O-F and O-N Does anyone have any suggestions? Thanks in advance for any suggestions Eric ... 18 Mar 2010 04:51

sum across worksheets conditionally
I have about 50+ worksheets in a file that I need to sum. However, I only want to sum some of the sheets if it meets a certain criteria. This criteria is located in a separate worksheet in the file that lists each worksheet name in one column and in the next column it list the type of worksheet. If a worksh... 19 Mar 2010 03:49