I have a workbook (Two.xls) that pulls data from another workbook (One.xls). When opening Two.xls i tell it to update data, and I then receive a message saying...

Hi I have a workbook with 60 sheets in it. I need to protect 52 sheets only. Is there a way I can do this collectively instead of each one...

Using Excell 2003. I have 7 cells in a row each with a different number in each cell. Selecting the first cell I wish to compare the number against a...

Hi, I have a program that uses 2 workbooks. Both must be visible. But the code workbook with the graphics cannot be closed by the right corner...

I am trying to have a 'DRAFT' watermark appear behind my document in excel. How is this done? I know how to do it Word... thanks.

How do I assign cell selection order in protected Excel worksheets?

Hello, I have two columns in the same sheet which contain cells with identical results. I want to delete any result that is the same in both columns. ...

I have several drop-down boxes in a file that have stopped working. I used them on Friday. I have not changed the location of the data referenced by the...

Workbook 1 Associate ABRAMS,TANJA BAILEY, NAKEYTA BAIROS, VERA BAKER,JANINE BANDISON,LINA Workbook 2

I would like the active cell (cell I am currently working in) to be a different color. Example: I am working in cell AD58 I would like for that cell to be...

How do you format a drivers license number? For example: Hxxx-xxx-xx-xxx-x, where x represents any number, but "H" represents any text? Do you have to use a...

Ahh..the search engine is disabled or i would use it... I ahve reports with an embedded object/company logo that is not displaying or printing on another...

I'm looking for a formula similar to the following, but one that works. =average(if((A1:A4="Jones")+(C1:C4"0"),C1:C4)) Column A represent sales rep column,...

Is there a way that Excel can remind me to do someting if data in a cell is changed? Something like a reminder or a pop up? I do not want to insert a comment.

What's the formula to put the sheet name into a cell? Thank you, MB

I made a worksheet of a list of books for a classroom library. The first column I named "Title"; the second one- "Author"; the third one "Genre"; ....and so...

I have applied an autofilter to my spreadsheet. I want to have a cell that will show me say Average Order Size. When I filter by Manger, I want to see the...

I want to fit a page to the printing sheet, like fit to page as you find in word and powerpoint

In a data file I just received, many blank fields show a single-quotation mark in the formula. The if statement does not recognize these fields as blank. ...

I am trying to create a worsheet that is linked to another(I know how to link) but I am having difficulties as I can only link to set cells. i am looking for a...