I want to create a pivot table using the pivot table wizzard from a worksheet
into a worksheet with the name table by running a macro. when I record the
macro I create the pivot table using the wizzard and it works fine but when I
try to run the macro again it errors "unable to ...

Dear Sir,
I have a ZoneWise Worksheet i;e
nz01,nz02,nz03.wz01,wz02,wz03,sz01,sz02,sz03 and so on.
Now i want to copy this data according to ZoneWise For example: nz01

I'M BAY CD IN CERIKO CITY

I have a wksht where I can see the gridlines, and have selected a checkmark
to print out with the gridlines. However, if I do a print preview or print,
the gridlines are missing in the output. I must have turned something off
accidentally.

This is my sheet
SLR NO.    NAME     POINTS            REDEEM
POINTS                                  TOTAL
001    HARDEEP    4500.00

I bring in a cube, then i browse the dimension. the dialog for
fitlering opens up ('label filters', 'value filters'...) and all the
values are checked. I want all of them to be unchecked, by default.
anybody knows of any way to do that?

When I export code, they currently default to Program Files>Microsoft
Office>Office10.  Is there a way to specify a new default directory
for my code?

I want to bring data into an excel 2007 worksheet that is stored in a sql
database table.
The idea is to parameterize the "where" clause in the sql select statement
limiting the result set.

I'm trying to do up a line chart based on a table on 'Project Summary Report'
sheet. I recorded a macro and Excel generated a series of codes as follows:
Charts.Add
ActiveChart.ChartType = xlLineMarkers

Has anyone else observed the anomaly of NOT being able to save a file to a
folder because of the folder name syntax?
In our company, we adopted a convention, many years ago, of using square
brackets, such as "[" and "]", when naming certain hard disk folders.  For

I have several older worksheets. Each one has a corresponding macro
(xlm) sheet. They are set up so that when a worksheet is opened, the
macro sheet opens in the background (hidden).
I want each worksheet to be the same size that exists when I save the

It seems to me that the behaviour differs depending upon the existance of files in the XLSTART folder: if that folder is empty, Excel closes correctly; if you have a PERSONAL.XLSB or similar file in the XLSTART folder then Excel doesn't close with the last workbook - presumably ...

working on an estimate and trying to figure out a way to take the results of
one cell and have its contents be automatically entered into another cell.
I have a subtotal line item for a particular category, I am wanting to
create a cover page showing the various catergories but ...

I am just not able to find out why my data is changing.
I had created a Pivot from a dataset.  The numbers matched. I saved
it. When I opened the pivot after a couple of days , I added a
conditonal FLAG column in the dataset so that I could bring that