any help on this? I would like to use the contents of a cell to auto-populate the header. Thanks for any assit.

I am working on a project related to spreadsheet security and would like to utilize the flexibility the "Allow users to edit ranges..." feature in Office 03...

i've just installed a new wireless microsoft keyboard and in excel it won't recongise me pushing f4 in the formula to change a cell reference to...

Is there a statistical whizz here who is also a golfer? I am having a little difficulty with one element of a calculation outlined in the USGA's Handicap...

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...

Is there a way to create either a shortcut (ie: ctl + n) or a toolbar icon for a Menu item that does not appear in the toolbar Customize/Command/Insert? I...

Hello, I have a worksheet where I use (or try to use) data validation from lists in several places. For some, but not all, of them I want to use the "Show...

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...

!!!PLEASE HELP ME!!! I have a big excel file set up where each row represents a specific city (this file is the "main file"). Then I have a seperate excel...

Hi, I have a table with cells that have conditional formats. If one condition is met then that cell become red. Not all cells are red on a column. I want to...

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...

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

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...

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...

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...

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. ...

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...

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...