Hi, I have a macro which refreshes 5 pivot tables, one after another. However, when a pivot tables data changes slightly, a message appears.."The refresh data...

I am located in Australia and my PC Regional Option is set as dd/mm/yyyy short date format. I receive reports from a US based system that generates an Excel...

Hi, I'm sure what I'm asking must have a simple solution, but I can't work out how to achieve it so thought I'd ask the experts. I have an addess list. It...

Is there anyway of attaching a toolbar to an .xla without using code? I am not a programmer. Subject: Can I attach a toolbar to an add-in? From: "Tom...

Given a workseeht table sort of like this: B C D ... H --- --- ---- ------ Buy 100 CACH @14.00 Buy 100 CACH ...

Hi, No matter what file I try and open, Excel launches and opens the same .xls file on the computer. This occurs when trying to open an .xls or .xlt...

Compile errors are often caused by bad/missing references. For instance, your BC.XLS has a reference to the Office Web Components 9.0. If the user does not...

I have a spreadsheet with about 20,000 rows of data and I am trying to eliminate unnecessary rows. Columns B&C contain numbers, and columns D through AR...

I am trying to import contacts into Outlook from Excell Version 2003. During the process I am getting a message stating that there are No Named Ranges. ...

About two weeks ago when I was trying to insert a row I found that my "Alt - I - R" function was not working. After asking around, I found this has happened...

Hi I hope someone can help with this: I use Excel VBA macros to open Outlook Calendar files across a network at work. Basically the code selects subject...

I have an issue with named ranges on an imported list. Excel changes the ranges on an import but not the adjacent columns. There are several issues wich...

I have a row with data added daily, newest on the top. Then I have a formula which calculates some output according to the last three inserted cells...

Windows 2000, Excel v8. Does anyone know the syntax for re-registration with Windows? We get a file already open error every time we launch a SS without...

I just installed Office 2003 and transfered excel files from the older version. The comments that I had created before I moved to 2003 look fine in the default...

I have a spredsheet to a few columns and one of the field is check numbers. This column looks like this: Check # 101 102 103 106 107 109 110 ....

I have a list of data in a different worksheet, and if I use vlookup ie. =VLOOKUP(AA4,'Dump'!$A$1:$DB$151,91,FALSE) - It brings back a value, however if I...

!!! THIS TIME NEXT YEAR YOU COULD BE A MAIL ORDER MILLIONAIRE !!! OUR MAIL ORDER STARTS, AND YOU ARE THE FIRST Dear Friends, Many people are going to tell...

Here's what I need to do: I have a rectangular array with values for a number of variables (columns) in a number of samples (rows). In another (square)...

I HAVE TRIED TO DO FORMAT, CELLS, ALIGNMENT & WRAP TEXT...IT DOES NOT WORK. I'M TRYING TO DO THIS IN A CELL THAT HAS BEEN MERGED WITH THREE OTHER CELLS TO THE...