Is it possible, when building an Excel 2003 pivot table to create links in
the pivot table that go to other areas within the current file?
Ellen

Saving Excel 2007 to HTML using frames causes unexpected problems. Is there a
way to save as HTML without using frames? As a table maybe?

Hello All,    
I have a Sheet in which i have 12 columns containing text Values, and 4
columns having numeric values. I have got the average by using SUBTOTAL
option of the displayed rows. Now I would like to know how can I get a copy

I have data in rows in one worksheet that I want to have linked to columns in
another sheet.  Is this possible?

Is there a way to save a previous multi-level sort in 2007?  I have a list
that I need to re-sort many times throughout the day. In 2003 I just went
back to data - sort and the old sort was still there, even after closing the
file and reopening.   Is that possible with the new ...

How do I add new stock symbols to Smart Tags?  Not all the symbols that I
type in on Excel Spreadsheet are being recognized, therefore, I do not have
the capability to conduct Web Queries. I have gone to MSN site and verified
that the stock symbols are correct.

I am having a problem shutting down Excel 2007.  I have run office
diagnostics, but it cannot solve the problem.
I am not doing anything special, just running normal workbooks, but when I
try to close Excel, it just hangs and then starts another worksheet.

how to get the MDX query that is fired from a pivot table of excel 2003
connecting to SSAS 2005 cube, within the excel itself? I can get it via SQL
Trace, but is there any way i can get it in excel file itself so I can
analyse it?

I'd like to create a rather unique (I think so anyway) chart but need
some help in doing so ... there are two parts to this chart ...
Chart data is set up like this:
Col E:  Store number

I am looking forward adding a time trend to a Taylor rule data set for
Central Banks rates forecasts in Excel. (for Eviews users, its is the
'@TREND' function)
It is usually associated to regressions to add a lag in your calculations,

I want to count how many times a specific ClockNo appears per Process Code
in a table of values.
However, I cannot add columns to my table, and the following formula added
to my pivot table returns a #N/A error... Please help:

I am trying to use the 'open workbook' event to automatically update links
(without I saying yes) in the opened workbook. However if the linked workbook
is protected I am asked for the password. How can I incorporate the password
in the 'open workbook' event so that it will not ...

Is there a way to protect a worksheet on a format area (freeze pane) only?  I
want someone to work on a worksheet but not change a certain format.
thank you

I had a DSUM formula in Excel 2003 that summed data from one file based on
criteria within another file; DSUM([Sales.xls]Billings!$A$:$Z$,15,$A88:$A89).
This worked just fine in Excel 2003!  Now that I am using Excel 2007 it is
not working...what am I doing wrong?  I tried ...

Hi I am having trouble with Excel 2007 - I created a solver macro (looping)
in excel 2003 and now in Excel 2007 is not working. I have added solver to
the vba reference but now I get a compile error - "Can't find Project or
Library" - well I copied the macro to another module and ...