I just got a new Dell with Office 2007. Computer is a Vostro 430 with 4GB of RAM and a 2.8GHz processor. Cut, copy and paste operate extremely slow in...

i cannot remove the password protection to open a excel file. i can open the file but cannot unprotect it. can anyone help ?

How do I delete a space at the end of an amount or text?

Hi MVP's And Sesons Greatings to All ! Need som help on this problem! I have i UserForm in wich i enter =E1 weeknumber, e.g.=20 current weeknumber. What i...

Can I VLOOKUP when the return value I require is in a column before the lookup column. A B 1 red 2 blue 3 green 4 yellow 5 white

I am asking for any help you can give me regarding the best way to import columns from a datasheet into another worksheet. I have many worksheets to...

I have a long list in columns A to I. In some cases, all the items in adjacent rows are identical, and I need to be able to find these as quickly as...

Hi, I want to check a number of VAT numbers using a formula, the first check is to ensure the number is 9 digits (may need to remove spaces to ensure clean...

My company has just implemented expiring passwords. Some of my users have created Excell workbooks containing multiple worksheets, each retrieving data from an...

Hi! I have a workbook with four sheets, and i'm writing a procedure where at some point i need to save only one of the worksheets as a new excel...

Hello, I haven't had any success in trying to do the following: I have a column of hours - all with .50 (such as 8.50, 7.50, 1.50, etc.) I am trying to...

"=?Utf-8?B?SWx5YSBCYWltZXRvdg==?=" wrote... My worksheet represents a list of entities E1, anb each E1 can have multiple of other entities E2 associated...

I would to know if anyone could answer a question for me? I am using Excel 2000 with XP Operating System. When I set up a spread sheet and adjust my cells for...

I have a worksheet with values for year and week number. I need to convert these to the descriptive month name. Some weeks cross month ends, but this is...

How do I accomplish this? I have a table - I'll give you an example of the 2 columns cell B6 = 2.5 cell D6 = 143 cell B7 = 2.6 cell D7 = 147 cell B8 =...

This is in a MS Office 97 Excel Workbook, although I have selected data validation for a cell the in-cell dropdown is not showing up. Of course some silly...

Can excel pick up totals on other sheets and workbooks for clients, where the clients information is never on the same row no. on each sheet, without it being...

Here is what I...

I thought I was getting this message when I refresh one pivot because I had multiple pivot tables on a worksheet. Whether I select Yes or No ("overwrite" or...

What is the correct formula for extracting data from a pivot table report which meets a certain conditional set of criteria?