I'm trying to work out my out of stack space problem and I'm trying to
load my forms by using
form1.show 0 and
form1.show vbModeless

I have an xls doc that I copy each year to start from again.
A long time ago I experimented with Macros but never used them but I managed
to grow the doc to a 16 MB file or something.
Even when empty (start of new year) the file is still that big.  I now have

I have received a spreadsheet from someone else that is acting
strangely, perhaps someone can help.  If I make a reference to another
cell, say I am in cell R3 and want to imput the value of A1, I would
simply input =A1 in cell R3 and the value of A1 is displayed: no fuss,

Hi, this is my first post.  I have a workbook containing several sheets.  I
went to rename one of them, and the data disappeared.  I got out without
saving and it came back, but I then seem to have hit the incorrect button
because now it appears to be really gone.

When i try to connect to an external data source to make a pivot table
i get blank values that should be blank.
i am hooking to a access database that is querying external SQL
databases.  Im bringing in 173 thousand records just into the cache

OK, OK...so (technically) I'm not a "new" user of Excel.  I've created simple
macros in older versions of Excel,  before macro and Visual Basic meant the
same thing.
I want to create a simple macro, but VB is foreign to me.  All I want the

I am using the sum formula to sum across rows.  The formula works, but for
one set of calculations the actual sum does not appear in the destination
cell, only a series of ####.  How can I get the actual sum to appear?  This
is only occuring for 1 set of the calculations.  All ...

I have created a Pivot table and to dynamically calculate a calculated
field depending upon the selection in a page field I have written a
small piece of VBA code in Worksheet_Calculate event.
But this disables/deactivates Undo/Redo button at the top.

In Excel 2007 I am trying to select an entire column to do the same thing
for each line.
Column c is hours worked, column d is pay per hour and I want to have column
e be the total $ for that day.

I have a workbook size of file is 17 MB. It contains 16000 rows, 5 colomns
had simple formulas copyed down accross to 16000 rows.
All the cells in the shhet have borders 56000 row. I selected the rows
between 16200 and 65000 and Edit>Clear>all

When I want to open my saved work in Excel, a message reads 'wait while
windows configures...' and after a while it will say "Error 1706". Can
anybody help?

I've run into an Excel 2007 Copy & Paste problem that I thought I would
share with the group.
If you open an Excel 2003 (or earlier) workbook in Excel 2007 and that
workbook has data and formatting on one of its worksheets including having

I have a Pivot Field and it has Column1 , Column2,
Column3,...................,Coulmn10 in columns.
My requirement is that I want to label / group
Column1-Colun5   as Column One

When i import data via a webquery from:
http://www.x-rates.com/d/EUR/table.html
I get different values than on the webpage..
When the webpage says:

I have a spreadsheet with a list of names on a waiting list, and I have each
row numbered incrementally using the formula =A1+1 etc.  However, when I
delete a row (when someone 'drops out' of the waiting list) the row numbers
below come up with an error (#REF!).