What I am trying to do: have several excel files with data and want to
consolidate in a single file
What I did: tried to paste all the data in a single file and create a pivot
from there... the problem is that I can not copy after reaching 65K

Hi - I have a spreadsheet with pages for 2000, 2001, 2002, etc - how do I
make a page in the spreadsheet that continually updates the totals/changes of
these pages?

How to validate the Cells in MS Excel, so that when the
cells are blank the sheet should not save and should warn
for inserting charectors/numbers

In a user form I have 6 radio buttons, 3  inside one frame, and 3
indentical inside another frame. I want to be able to make it so that
the radio button selected in one frame cannot be the same in the other
frame? Hopefully this can be solved!

i am a new to excel.
i recently tried to build a page that calculate profit by agent an
agents's account.
our company have about 10 agents and each agents have about 10 account

Good day to all,
why my computer cannot open excel file directly double click the file.
very appreciate for those are help me.
Thanks.

Hello, I was wondering if anyone can tell me how to code or input this.
What I want to do, is, when the date is input into a cell in on
column, the corresponding day of the week appears in the column abov
it. And needs to do this for 7 days ahead of it. Does this make sense?

when i type 1-3, it auto formats and writes 1-Mar, as the date, but i want to
leave it as 1-3

Hi, Gurus.
  I'm using Excel for one of my classes and having this problem. Let's say,
I have a number of sample {x, y} pairs. I have produced a correlation graph
y = f(x) with XY (Scatted), and have the line smoothed.

I just wrote a simple program and I would like to make it look clean an
simple by removing all of the unecessary items from the menu.  And b
limiting the viewing area.  There is a plug-in called Mortgage Genie o
a website called moneycops.com.  The program is free and it's a perfec

I have a column of data in the following format
column A
John B. Smith
What I want to do is split this column into three separate column so that it

I need a six week cash flow template which includes the following:
Beginning checking account balance
Accounts Receivable:
    30 day

I have several files I need to convert from .wks to .xls format. I no longer
have Microsoft Works, so I am unable to save with a different suffix.

I am running office 2000. I recently updated Outlook to Outlook2003. Now,
none of the other applications can email. When I click the icon I get an
error that the email application can not be found. I was able to send an
excel sheet as an attachment, but I need to be able to send ...

I know there is probably an easy answer to this, but how can I remove
header from all of the pages following the first?
I posted this to the wrong forum first, sorry
--