The calculation option in Excel 2003 keeps switching to Manual. I choose Automatic and when I reopen Excel, it's back to Manual again. Haven't had this...

I am working with a spreadsheet totaling 200,000 items. I am trying to copy and paste 26,000 visible rows. Keep getting "too complex". I've tried Move...

So I have a list of address, where the entire address is in one cell, I want to extract just the email address from the field. Here is a quick example: ...

I do not see the option to unshare the microsoft excel workbook in Office 2007. does anyone know how I can unshare the workbook?

I have a user who is running office 2007, and is trying to protect a workbook in Excel. I know how to do this part. The question is though, is it possible to...

How do I change the properties for a charts that are displayed on a worksheet. I'd like to set it up so that it doesn't resize, but moves and I just can't...

I would like to have results of AND() appear as 1 or zero instead of TRUE or FALSE. I tried to use IF to check for true or false but for some reason this...

I use find key alot, and in 2007 version it is difficult to see the data you searched on is highlighted. How can you change this so when your data is found...

I have to use 97-03 file format within my office environment but am sick of the stupid dialog boxes that keep resulting. In Word, I found an example of...

Hi, I need to find corresponding references in a sheet and then return the name next to the reference. How do i do this? Thanks

I don't know if there is some configuration I've turned on in my home computer or not, but excel keeps leaving around .tmp files when I edit all of my xlsx...

I have ten worksheets in one workbook and I need to combine the (10) worksheets information into another worksheet. I do not want the totals from each sheet...

I NEED THIS formula (COUNTIF ($D$62:$D$97,"=X") FOR THE NEXT COLUMN ($E$62:$E$97,"=X" how DO I COPY THE FORMULA INTO THE NEXT COLUMN AND SEE THAT THE...

Hello! I have a document containing about 70 pages of links, column D is the current links and column C is the links that we will be replacing the current...

Hello all, I would like to add some conditional formatting on dates but I am unsure on the formula. What I would like todo is color code a cell containing a...

Following is the data I have. I would like a formula to find all the items in Column B that is between 0300 and 0700 then using the data from column D,...

Hello, I'm formatting a table and cannot seem to figure out how to add a 3d look to my table. If I use auto-format I have a 3d effect available but not...

When creating a new document in 2007, I'd like to click Save and have the system prompt me for a file name. In 2003, if you create a new document and click...

Hi, Lets consuider the following table: A B C 1 Code Zone A Zone B 2 B22 25 3 C41 ...

Help! I have 1 master spreadsheet with all files and 2 seperate worksheets (labeled NVS and FSV). I need to find out how to indicate if the file on the...