A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Powerpoint, Publisher and Visio » Powerpoint
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Hyperlink to specific worksheet in XL



 
 
Thread Tools Display Modes
  #1  
Old May 5th, 2010, 06:42 PM posted to microsoft.public.powerpoint
Mark[_59_]
external usenet poster
 
Posts: 72
Default Hyperlink to specific worksheet in XL

I need to link to a specific worksheet in an excel document from
powerpoint. There will be around 30 different worksheets linked from
several slides in the presentation, and I'd like to keep them all in a
single spreadsheet, instead of having 30 different documents.

Can this be done? I thought there was a way, but haven't been able to
figure it out yet. Note - this needs to work cross-platform (VBA is
out), and possibly needs to work with version 2003 (I am currently
using 2007).
  #2  
Old May 5th, 2010, 07:34 PM posted to microsoft.public.powerpoint
Mark[_59_]
external usenet poster
 
Posts: 72
Default Hyperlink to specific worksheet in XL

Ok, now I'm really getting ****ed at Microsoft. I found how to get
this to work. Setting the link to this:

ExcelFileName.xls#'WorksheetName'!A1

....will get it to open the excel document to the specified worksheet
on cell A1. BUT this does NOT work cross-platform on a Mac! WTF,
Microsoft? You can't even get your own programs to work consistently
with each other?

Am I missing something, because I can't seem to get this to work at
all. This is causing me major problems with this project I am working
on. My client does not want to send out 30 different linked Excel
documents, and I'm not very happy with providing a solution that does
not work properly for all of their users, although that is beginning
to look like what they are going to have to accept.
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:51 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.