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

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

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

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

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

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

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

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

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

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

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

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