Hyperlinking Excel to PPT address changes

Hi Folks! I am inserting a hyperlink in PPT 07 to an Excel file. I am 
creating the hyperlink address to be in the following format for Excel: 
Filename.xls#’worksheetname’!A1. I of course am using my own titles and cell 
referencing. However, when I create this address in the link, save the PPT 
file, close it, and reopen it, the address in the hyperlink address is 
changed to just Filename.xls and leaves off the worksheet and cell locations 
as well. The hyperlink address will not retain that info for some reason. Has 
anyone ever seen this? I am using PPT and Excel 07 with SP 2. Thanks!
0
Utf
3/18/2010 6:58:15 PM
powerpoint 2011 articles. 0 followers. Follow

1 Replies
940 Views

Similar Articles

[PageSpeed] 50

In article <537B67B5-3D45-4D8C-AF3C-2B43F389C0E7@microsoft.com>, Matt wrote:
> Hi Folks! I am inserting a hyperlink in PPT 07 to an Excel file. I am 
> creating the hyperlink address to be in the following format for Excel: 
> Filename.xls#�worksheetname�!A1. I of course am using my own titles and cell 
> referencing. However, when I create this address in the link, save the PPT 
> file, close it, and reopen it, the address in the hyperlink address is 
> changed to just Filename.xls and leaves off the worksheet and cell locations 
> as well. The hyperlink address will not retain that info for some reason. Has 
> anyone ever seen this? I am using PPT and Excel 07 with SP 2. Thanks!

Are you certain it's 

Filename.xls#�worksheetname�!A1 

and not 

Filename.xls#worksheetname!A1

I've never run across one with quotes before and would be curious to know how it 
was created if they're really part of the link.

But this business of PPT tossing the entire subaddress (the # and everything to 
the right of it) has been reported.  I thought it was fixed in SP2 but perhaps 
it's fixed in one of the later hotfixes.  I can't repro it here any longer.

Ah.

http://support.microsoft.com/kb/938539

However, this would have come out well before SP2, which leaves me 
headscratchin'

Could you do Office Button | Resources and check on the Powerpoint version... 
post back the entire version string.



==============================
PPT Frequently Asked Questions
http://www.pptfaq.com/

PPTools add-ins for PowerPoint
http://www.pptools.com/


0
Steve
3/19/2010 2:57:36 PM
Reply:

Similar Artilces:

Changed behavior of overriden OnCmdMsg(...) after migration to Visual Studio 2005
Hello, please assist in solving critical problem which I faced after migration of my project to Visual Studio 2005 from Visual Studio 6.0. My project is a document-view based application, view class is inherited from CFormView, it is a dialogue with multiple edit fields. For example, field m_Edit1 has OnKillFocus(...) handler defined which validates user entered data. The next field m_Edit2 doesn't have this handler. At the same time I have overriden method OnCmdMsg(..) in my view class. This method performs some checking for content of m_Edit1 when EN_KILLFOCUS is sent and calls OnCmdMsg(...

Excel 2007 not refreshing screen
I am running Office 2007 Pro Plus on Server 2003 R2 with terminal Services. When users are using excel, after a few hours they will get black areas on their screen that appears to be areas not refreshing properly. This issue will then spread to other applications. Eventually they will get a resource error message popping up on their screen. If they close excel everything will work normally again. I have all updates installed to current. When this happens I have checked available resources on the server and there is sometimes 2 Gigs of Ram available and only 20% of the processor is being u...

Change allignment on double catagory axis
Good Afternoon. I am running windows xp prof and have this issue with both excel 2007 and 2003. I have an area chart which has double information in the bottom catagoryaxis. It has one date for two columns. When I got rotate the information on the catagory axis. it only rotates the information that comes first and not the date. How can I get excel to change the alignment of all date in the catagory axis. Any information you can provide would be greatly appreciated... Thanks in advance... Myssie You get the orientation Excel gives you. You may get some control by changing the ...

Adding highlighted cells only -Excel 2000
Anyone know if there is a way to add only cells that are highlighted? I would like to see quick sums of only the cells I have highlighted and hoping there might be a way to do this quickly and easily. I have to do this many times with various cells with differing number values. Thanks in advance K By "highlighted" do you mean colored or simply selected? If the latter, use the Sum on the Status Bar. If the former..................... You will have to use VBA to grab the colorindex of the cells. Do you want to do that? See Chip Pearson's site for UDF's for working with co...

How do I creat a doc with excel pages and different size word doc
How do I creat a doc with excel spreadsheets of different sizes and word doc of different sizes. ...

Global Variables losing scope in Excel when developing
This is a multi-part message in MIME format. ------=_NextPart_000_000C_01C42C80.D0AD9790 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I have a vba module inside an Excel add-in with a global variable = pointing to a class in an external dll, in the form Public MyVar as new MyLibrary.MyClass The problem is that when I am developing and testing the add-in, the = variable loses scope (not initialize). I have to close everything and = restart Excel. Then all is OK. Any suggestion? PD. If a declare the variable without "new", ...

Printing from an excel spread sheet to form question
Hi, A friend picked up a ton of contiuous paper, 3 part, at a very good price, and wants to use it for billing. The paper alreadys has a form on it with a place for address, and the usual billing fields, amt, quantity, price per unit, date, etc. If we make a big spreadsheet, big to us would be about 1000 customers, is it possible to use that sheet, as a database, from which to draw the information from and then print on the pre-formated form feed paper into the right places? I know access can do this, but nobody in the office knows how to run access, and nobody wants to learn how either. T...

Multiply two columns in Excel or one column by one number
I am a beginner at this. Using Excel, all I want to do is to multiply 2 columns together to give a third column. For example, a list of numbers in column A against a list of numbers in column B to produce a column C - (A2 times B2 to equal a number C2)) or to multiply all the numbers in one column (like "calories" or A2-A18) times one number (like 0.2) to produce a third column. I tried to do this but the results replaced the numbers. and to multiply one column times two other numbers. I'm going nuts (I'm swearing all over and I don't usually swear) trying ...

excel #84
My computer crashed and when it came back up I didn't have microsoft excel, word nor powerpoint. Can you help me restore these programs? Perhaps you have just lost the shortcuts to these programs? Go to Start>Run and enter "excel.exe"(no quotes)>OK Does Excel start up? Open Windows Explorer and go to Program File\Microsoft Office\Office. Can you find Excel.exe or Winword.exe or any other Office executables? Do a Start>Search>Files and Folders for these files. Make sure your Folder Options>View settings are set to "show all hidden files" and "...

excel payroll calculator for canadians
Can anyone advise me on how to setup a payroll calculator in excel that would automatically deduct income tax, CPP, and EI. I've looked at the MS template and it is great. Is it possible to create a template like it, but have it calculate the necessary canadian deductions. Any help or a template would be great. Thanks! Can you post the link to the template you mentioned, so I can have a look. Am I correct in my understanding, you want to be able to, for example, input a monetary amount, and have the neccessary deductions calculated? Is that right? -- VBAvirgin -------------------...

Excel vs Access #2
Is there a good criteria that one could use to determine whether data should be put into a sophisticated excel spreadsheet or an Access database? I am trying to determine the best location for a new statistical project I am working on. Thanks! Amy "cvgairport" <cvgairport@discussions.microsoft.com> wrote in message news:D31BD327-BFE9-4C61-9448-4A0D40A0EB3F@microsoft.com... > Is there a good criteria that one could use to determine whether data should > be put into a sophisticated excel spreadsheet or an Access database? I am > trying to determine the best loca...

Excel 2007 RTM Bug
I'm using Excel 2007 to Connect to a SQL Server 2005 Analysis Server. The Show / Hide (+/-) buttons are not displaying when I add more than one dimenstion to a Row Label. This functionality worked in beta 2 but not in beta 2 trf. Excel 2007 is installed on the same machine as SQL 2005 AS. Thanks in advance for the help ...

How do I input email addresses in Excel without the hyperlink,
I need email addresses in my excel worksheet, but they must be text, not hyperlink. Iv'e been copying them to a word doc, then doing the "paste special" to put it in excel as text. That works, but is very time consuming. Is there a way to format a column so emails are text only? -- "You can have everything in life you want, if you will just help enough other people get what they want." -- Zig Ziglar Precede the email address with an apostrophe (') when keying. HTH Jason Atlanta, GA >-----Original Message----- >I need email addresses in my excel wor...

CHANGE DATES
I WANT TO BE ABLE TO TYPE 6 DIGIT NO. EG 010101 AND EXCEL CHANGE IT TO 01/01/01 HOW CAN I DO THIS SIMPLY THANKYOU See your response in Excel.misc newsgroup. And in addition to not using Caps lock, please don't multipost Frank ME wrote: > I WANT TO BE ABLE TO TYPE 6 DIGIT NO. EG 010101 AND EXCEL CHANGE IT > TO 01/01/01 HOW CAN I DO THIS SIMPLY THANKYOU ...

how do I import data in excel form SQL server?
Hello All, I've been trying to import data into excel from our SQL server. I have the sql script yielding the results. The real problem is when I use the data connectivity wizard, it only allows you to select one table from the database in your SQL server. However, my script involves two tables with a join. Any ideas would be helpful Thanks, Mitch Asuming you have rights on the Server, convert your 'script' (by which you probably mean query?) into a view. If you don't have adequate rights, then use MS Query to connect to SQL Server and use your que...

Follow Hyperlink to PDF page
I am currently following a hyperlink to a pdf document. Is it possible to use the subaddress to define which page number? You'll have to switch and use a reference library for that. If you google the subject you will find a few solutions. Below is one. http://www.access-programmers.co.uk/forums/showthread.php?t=100665 -- Hope this helps, Daniel Pineault http://www.cardaconsultants.com/ For Access Tips and Examples: http://www.devhut.net Please rate this post using the vote buttons if it was helpful. "Confused Slug" wrote: > I am currently follow...

QUERY: API/SDK for Excel
Is there a MS Excel API/SDK? I just noticed a Excel plugin which was a dll file. I am wondering whether it's possible for one to create his own plugins for Excel and how to go about it? Also, is it possible to link in Excel with another application, say a 3rd party program. So that Excel worksheets and cells correspond to values stored in a 3rd party program's database. > Is there a MS Excel API/SDK? I just noticed a Excel plugin which was a dll > file. I am wondering whether it's possible for one to create his own > plugins for Excel and how to go about it? I ...

oma not working after exchange address change
last night i changed the internal address of my network, this network consists of: windows 2003 dc windows2003 exch sp1 netscreen firewall oma was forwarding a copy of email to the handheld device, after i made the address change oma will not forward a copy of email. Also when i browse to http://servername/oma from ie6 i get prompted for log on then an error message of: A System error has occurred while processing your request. Please try again. If the problem persists, contact your administrator i belive this is all related. if anyone can help to resolve this i would really appreciate it ...

Can we change the default outlook form?
Hi all, We need to change our outlook contact form to the customized form. Is there a way to change outlook uses to use the customized contact form instead of outlook default form? exchange 2003 /outllok 2003/outlook 2007 envir. thank you. Hi, Please find below the link - "Tutorial: Creating and distributing custom forms with Outlook" http://office.microsoft.com/en-us/outlook/HA012106101033.aspx Regards, Vladimir Meloski "ed" <ed@discussions.microsoft.com> wrote in message news:418F92EF-DE02-4642-8609-8E35EE9755C0@microsoft.com.....

Linking to individual Excel worksheets
I am am currently linking to excell workbooks from a presentation using Insert-Object-Current File with the linking option selected to display updated graphs on powerpoint presentation given through out the month. However this option only seems to link to the workbook itself. Is there a way to link to a specific tab with in the workbook? Thanks. On Jan 13, 2:02=A0pm, AL <A...@discussions.microsoft.com> wrote: > I am am currently linking to excell workbooks from a presentation using > Insert-Object-Current File with the linking option selected to display > updat...

Excel formula not updating unless spreadsheet is saved
Hi I am running a spreadsheet where formulas link into other worksheets i.e. ='ASSORTMENT SHEET'!N23. I have noticed that when I update the cell reference above, the linked cell does not update automatically and only updates when I click save. I have since tested a new spreadsheet up, set up a linked cell and this refreshes immediately without having to save. If anyone has any ideas this would be very helpful. Thank you Brian Turn Calculation option to "Automatic" Gord Dibben MS Excel MVP On Thu, 29 Apr 2010 08:36:31 -0700 (PDT), "brian.b...

Excel in OS X
When I click on Format - Cells all I get is the sun spiral. The only way to get rid of it is Force Quit. Needless to say I can't format dates or numbers. Hi Merritt, Take visit to http://www.microsoft.com/mac/downloads.aspx and get the updates: 10.1.2 10.1.4 10.1.5 Install them in that order, then run Disk Utility First Aid to Repair permissions. Let us know with a reply posting whether that fixes things for you. -Jim Gordon Mac MVP All responses should be made to this newsgroup within the same thread. Thanks. About Microsoft MVPs: http://www.mvps.org/ Before posting a ...

Excel 2003
Word 2003 has a feature whereby you can select part of the text in a cell and apply shading to only that text. Does Excel have such a feature - or something similar? I need to put black shading on a few words of text in a cell, but not on ALL the text in that cell. You can do this if the cell contains text. You can't do it if the cell contains a formula. Select the cell, then highlight the appropriate characters in the formula and apply the formatting. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Peppermint" <P...

can I autopopulate from a long drop down list in Excel?
I have a very long list of referring physicians in a drop down list for data entry people to populate. I would like them to type in the first 3 characters and be immediately directed to that area of the drop down list. Is this possible? Thanks! Instead of the dropdown. This will take you to the name in col J Sub gotonfirst3letteredname() myname = InputBox("Enter first 3 letters of name") If Len(myname) <> 3 Then MsgBox "THREE letters" Exit Sub End If Columns("J").Find(What:=myname, After:=Range("j1"), _ LookIn:=xlValues, LookA...

Excel Styles Problem
I created a spreadsheet that uses several different styles. All styles use the same type and size font but the shading, font color and borders are different. The normal format has no borders, no fill/pattern, and the text is black. Another fill is "User currency format" , it has borders on all sides, a blue fill/attern and black text. In some of the cells I have not applied a style to (at least no intentially), the cell styles are "Normal" before I make an entry, if I enter text the cell remains formated with the Normal style but If I enter a number the style cha...