Cell A1= $100
Cell A2= $100
Cell A3=   =sum(A1+b1)
How do I protect the formula in A3 from being deleted with the deI or

My employer uses MS-Outlook to book PCs in the training room.  I have
to submit weekly usage reports for each of the PCs.
I can export from Outlook to Excel and although the start and end times
look like text '08:00 they subtract OK.  There could be several short

I have the following code that: when pressing "Ctrl+E" runs a macro
(called "Prepare_External") that runs the below code.  This code
protects all the worksheets, hides one particular sheet called "Input"
and then protects the workbook.  But before I protect the workbook I

I need help with excel.  I have a product list in excel where products are
are Identified with a four digit code.  E.G.
Code     Product    Desc                        Net               VAT        
Total

I merge cell in col b and now I want to delete duplicate records.
What is the formula if i want to delete unwanted rows e.g
Available file
COL A  COLB

I have a data file (at http://www.weatherweb.net/cliall.dat) which contains
daily weather data from 1881 in the format:
dd,mm,yy,max temp,min temp, rainfall, sunshine, wind speed, wind gust,
pressure

This just recently started happening.  When I open Excel, either from a
shortcut key or by double clicking an Excel file, I get a series of error
messages saying that Excel can't open Access files.  After clicking OK to
all of them, it finally opens the Excel startup spreadsheet, ...

Received a 2007 Excel file, I have 2003 Excel.
I tried to open this file, with no success.
Any ideas??   Skip

I have set the following data name:
=OFFSET(Par!$D$2,0,0,COUNTA(Par!$D$2:$D$201)-COUNTBLANK(Par!$D$2:$D$201),1)
How to get all data in the right onummeric order?
It seems to be with offset($D$2,0,0,counta($D:$201),1).... likely looks

I live in South Africa, and I have an interesting problem that persists
in
Excel 2003 and 2007.
=TEXT(NOW(),"dd mmm yyyy") returns 15 Dec 2006

This is probably really simple - I want to record (or get) a macro that
will do a "File-Save As-'whatever is in cell D3.xls'"
I've tried to record such a macro myself and thought it would be easy -
but when I try to run it, it re-enters whatever was in cell D3 during

I need to have a row hidden or revealed based on a value in cell A16.
I have this code in the worksheet which works fine EXCEPT it apparently
resets the Undo stack and I don't have any undo capabilities in any
workbook that is open at the time.

Hello experts!
Excel has a nice option to format various parts of a chart using cell
values.  Can the same be done for headers/footers, e.g. that the header
displays value of cell A5.

I'm not very good with Excel, which must be obvious or I wouldn't be asking
for help would I?
I have a spreadsheet which has grown to hold 23,562 data entries from 7888
name categories, and I need to trim it by deleting old and excess data.

Just installed Office 2007 on my fathers machine, everytime we do a new
worksheet and type in 12345 it changes to 123.45.  It's like a global
setting but we can't figure out how to remove it.
Any ideas.