Hi, since a few days my Excel 2007 hangs up realy frequently. It happens
that, even with a white workbook after a few seconds (let's say 30-40
seconds) I've started Excel and I simply move around with the arrow
keys, Excel hangs up for about 60 seconds.

I have some data like this
A    B       C
IN   SA     Formula
IN   SB     Formula

Is there any way to not lose border formatting after refreshing a Pivot
Table?
Thank you.

I was sent a wb3 file and cannot open it with Excel 2007.  Any suggestions
how to opent his spreadsheet?
Thanks,
Steve

I have an Excell 2007  spreadsheet with borders around selected
cells,  the spreadsheet is protected so my formulas cant get
corrupted, but with some cells that are unlocked for user data entry.
But when you copy and paste in these user entry cells the borders are

I have sheet named Walk In containing details for the customer.
In this sheet, column A named Arrive contains the dates of arrival of
the customer and column C named Depart contains the dates of departure
of the customer.

I'm using Excel 2003. My data validation lists have stopped working on one
sheet in my workbook.  It is working on all other sheets.
I have googled the problem and found the following advice:
1. Make sure freeze panes is off.... check.

Imagine a set of data as set out below:
Column A  Column B
Apples       24
Pears        36

I have written a procedure to use copy/paste special for several dozen cells
individually.
In two cases, the destination cell is merged so I unmerge before pasting
then remerge.

I am trying to print a landscape page, with headers and footers, with
the sheet fit to 1x1 page.  I want to have footnotes at the bottom of
the page, which I am doing just by inserting enough rows manually
until the sheet starts to get squashed width-wise (before footnotes,

Hopefully just a quick question, I have some code that gets run
everyday and it inserts sheets in a workbook and renames each sheet to
specific value. The next day the same code gets run and it deletes the
worksheets that i added the previous day and adds some new worksheets,

I have the following formula counting "YES" in a column range 'Tests
1'!I3:I1000 I now want it to sumproduct the "YES" in 3 column ranges
'Tests 1'!I3:I1000, 'Tests 1'!Q3:Q1000 and 'Tests 1'!X3:X1000
=SUMPRODUCT(('Tests 1'!$D$3:$D$1000="Derbyshire")*('Tests

I am using 97 Excel and WinXP Pro SP3.
When spreadsheets (xlsx) are open, they are normally open from the left
edge.
But one spreadsheet opens close to the left edge (about 3 inches from the

I am trying to creat a formula in my accounting spreadsheet that will put the
total in the appropriate column by the date column plus 0-30 days or next
column plus 31-60 days. I tried the sumif and kept getting errors. Help.

Hopefully just a quick question, I have some code that gets run
everyday and it inserts sheets in a workbook and renames each sheet to
specific value. The next day the same code gets run and it deletes the
worksheets that i added the previous day and adds some new worksheets,