I send out Excel reports in a Reporting Services subscription that contain a hyperlink embedded in one cell. When clicked, it calls a ..wav file on my...

I send out Excel reports in a Reporting Services subscription that contain a hyperlink embedded in one cell. When clicked, it calls a ..wav file on my...

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...

Hello, 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...

Excel 2003 Question: How to write an if then formula to take the "0" out of the linked pages in the spreadsheet? Can anyone help me with this? Thank you.

I try to open a file in excel and it throws up an page error! The error message it throws up is an invalid page fault error OR an MSO9.DLL error! What does...

Consider the the below example: Sheet1: (This is what I have) A B C D E F 1 x x x y y y 2 x x x y y y 3 x ...

Hi, 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...

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...

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...

Hello, I would like to make link to different worksheet with name specified in different column eg. A B 1 Sheet1 =SUM(A1!B4:B10) 2 Sheet2 ...

No surprise, considering the post. Amusing that the phone & email address were next to illegible because of his color scheme. HTH, -- George Nicholson Remove...

I cobbled this macro (borrowed from snippets of several others) that works great. I would prefer a simple OLE patch, but it seems the simplest is a lengthy...

I have a powerpoint linked to parts of 20 speadsheets. In Office 2000, when I move the files to a different machine, ppt's update links says it can't find the...

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...

Try Ctrl+Alt+F9 If that doesn't do it try a macro that does Application.CalculateFullRebuild if your version of Excel supports doing that. Bill Manville MVP -...

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...

Bill Manville Wrote: If I have understood you correctly, you want someone to be able to enter data onto one sheet and then have it stored in a relevant row...

Hi, 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...