IN PIVOT TABLE, I WANT ONE OF THE ROW FIELDS TO BECOME ALL HYPERLINK. IS
THIS POSSIBLE ??
ALSO CAN WE MAKE THE VALUES HYPERLINK TOO ??
Example, the role field is fruits. Page field is country.

Can I link Pivot Table 1 in WorkBook B to a pivot that exists in Workbook A?
Thanks & Cheers

I have a query in Access that is linked to Excel.  The query produces
more records each month.  However the Excel linked data only shows the
number of records which i could originally see when I did the paste
special and "link".

Excel 2003
Question:
How to write an if then formula to take the "0" out of the linked pages in
the spreadsheet?

I have a spreadsheet (on Excel 2000) which used to draw data from
several external data providers. I have cleaned up all reference to one
of them, both in the spreadsheet and in the accompanying macros.
However, everytime I start the spreadsheet I get prompted to load

Is it possible to update links in just one worksheet of a workbook?  I
have a workbook with 12 worksheets, one sheet for each month, and would
like to update the current months links instead of taking the time to
update all of the worksheets. Thanks in advance for any help.

when i click a hyperlink targeted to a pdf-file, acrobat starts but
the file does not open. The strangest thing....I'm going crazy. Help!

I need to move Excel files to another PC. Some of the files have references
to Excel workbooks. The number of linked workbooks for each file varies from
30 to 120.
When I open such a file it tries to refresh the links, but in vain. The only

I would like to make link to different worksheet with name specified in
different column
eg.
  A             B

I have a powerpoint linked to parts of 20 speadsheets.
In Office 2000, when I move the files to a different machine, ppt'
update links says it can't find the links (a familiar story, excep
with a powerpoint twist).

I have a workbook which contains an inventory of computers, and it works
well in a single worksheet - not very complicated.  I'd like to have a 2nd
and 3rd worksheet within the same workbook which show a subset of rows from
the 1st worksheet, and are automatically kept in sync ...

I have a very complex workbook that won't automatically update formula
results which contain the vlookup function to another worksheet. "F9" doesn't
update the formulas but clicking in the formula (making it active) does.  
There are thousands of these formulas which need to be ...

Hi, I'm new and stuck trying to design an Excel worksheet with macros
that import data from an Access database to populate the spreadsheet.
It works fine on my machine, but when I try to move it to another
machine the excel file loses the location of the database and comes up

Bill Manville Wrote:

I've got a workbook with various links into it (as shown via Edit,
Links...). However, I cannot find the cells that are linked. Can anyone show
me an easy way of finding them out?
Thanks,