I have a spreadsheet which contains info imported from another system. I
want to give users the chance to add records but they must follow the rules
so that the data remains consistent.
The problem I have is that there are 4 fields that I would like to have

My worksheets only need 1000 rows but the worksheet remains at 65,000+ rows.
I have 1 GB or ram and 6 worksheets causes problems. How can I set a default
to limit the max number of rows and columns.
Thank you

I added a macro to my workbook that updaets a pivot table on fiel-open.
Now I want to turn it off.
I edited the visual basic page where I added the macro code, and took out
the text I added.

I have a spreadsheet that contains the following:
Rows = Products
Columns = Months
Data = how many products sold in each month

can anyone tell me how to put differents formulas in excel n kindly also give
me farmula's too.
with best wishes
M M Imran

Excuse the primitive nature of the question; I searched for the
answer in a couple of Excel groups, but I suspect it's so simple
that the question isn't asked.
I rarely use Excel, but I need to produce a running total: I

I'm using Excel to list my film inventory.  I would like to cross reference
it to actor's names, ie Airforce 1 x Harrison Ford Harrison Ford x Airforce
1.
Harrison Ford x Airforce 1.

How can I get a cell (row) to automatically resize vertically with the
amount of text in it ??

I'm using XP and Office 2000.
I just had a problem with a lookup that I can't get it to do what I
want.
=VLOOKUP(E2,Sheet2!E:E,1,0)

What's the purpose of creating a chart in Excel from the data in my worksheet?

Using XP and Office 2003.
When I add, change, or delete information from my data worksheet, I know
that I can just click "refresh" on my pivot table and all  the changes are
picked up.  However, that is not the case when I add a new row of

So here is the situation.  I have a million buttons (checkboxes or
radio buttons in excel) on surveys that all have captions.  We had to
translate these surveys for a German client.  Now i have to go back in
and change all the captions.  I am using keyboard shortcuts to

When cutting and pasting data, is there a way to turn off Excel's (annoying)
habit of automatically converting a cell defined as "Text" to a "Date"
format? For example:
1. Create a new worksheet

Thanks in advance for any help

Hey all-
I'm having a problem with extending list formats and formulas using
Excel 2000.  I know there are limitations to what that feature can do,
but I thought I'd check here, since I have a very simple example that