How to open linked PDF with Preview, not Word

  • Follow


Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel

I'm setting up a record of invoices sent and payments received. I send invoices as PDF's, and want to record the customer, invoice #, etc. as well as a hyperlink to the invoice on my local drive, in an Excel spreadsheet. <br>
I'm able to successfully insert a hyperlink to a file in a cell. When I click the hyperlink to open it, however, it uses WORD to open a PDF. When Word finally opens, it tells me it can't read the PDF. (Big surprise!) <br>
How do I tell Excel to open a linked PDF with Preview? I can't find an option for that anywhere. Do I need to hack an XML file somewhere? <br><br>Thanks, <br>
-Tim
0
Reply tdi 2/1/2010 8:53:04 PM

> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--B_3347886514_62943952
Content-type: text/plain;
	charset="ISO-8859-1"
Content-transfer-encoding: 8bit

On 2/1/10 3:53 PM, in article 59bb20e0.-1@webcrossing.JaKIaxP2ac0,
"tdi@officeformac.com" <tdi@officeformac.com> wrote:

> Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
> I'm setting up a record of invoices sent and payments received. I send
> invoices as PDF's, and want to record the customer, invoice #, etc. as well as
> a hyperlink to the invoice on my local drive, in an Excel spreadsheet.
> I'm able to successfully insert a hyperlink to a file in a cell. When I click
> the hyperlink to open it, however, it uses WORD to open a PDF. When Word
> finally opens, it tells me it can't read the PDF. (Big surprise!)
> How do I tell Excel to open a linked PDF with Preview? I can't find an option
> for that anywhere. Do I need to hack an XML file somewhere?
> 
> Thanks, 
> -Tim
I don�t think you need to hack anything. Go to the finder and right click a
the pdf file. Check the open with option to make sure it points to preview
or Adobe reader or something other than WORD. You may have to restart the
machine after you do this to make sure Excel knows about the change.

-- 
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom


--B_3347886514_62943952
Content-type: text/html;
	charset="ISO-8859-1"
Content-transfer-encoding: quoted-printable

<HTML>
<HEAD>
<TITLE>Re: How to open linked PDF with Preview, not Word</TITLE>
</HEAD>
<BODY>
<FONT FACE=3D"Lucida Grande"><SPAN STYLE=3D'font-size:10pt'>On 2/1/10 3:53 PM, =
in article <a href=3D"59bb20e0.-1@webcrossing.JaKIaxP2ac0">59bb20e0.-1@webcros=
sing.JaKIaxP2ac0</a>, &quot;<a href=3D"tdi@officeformac.com">tdi@officeformac.=
com</a>&quot; &lt;<a href=3D"tdi@officeformac.com">tdi@officeformac.com</a>&gt=
; wrote:<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE=3D"Lucida Grande"><SPAN STYLE=3D'font-size=
:10pt'>Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processo=
r: Intel I'm setting up a record of invoices sent and payments received. I s=
end invoices as PDF's, and want to record the customer, invoice #, etc. as w=
ell as a hyperlink to the invoice on my local drive, in an Excel spreadsheet=
.. <BR>
I'm able to successfully insert a hyperlink to a file in a cell. When I cli=
ck the hyperlink to open it, however, it uses WORD to open a PDF. When Word =
finally opens, it tells me it can't read the PDF. (Big surprise!) <BR>
How do I tell Excel to open a linked PDF with Preview? I can't find an opti=
on for that anywhere. Do I need to hack an XML file somewhere? <BR>
<BR>
Thanks, <BR>
-Tim<BR>
</SPAN></FONT></BLOCKQUOTE><FONT FACE=3D"Lucida Grande"><SPAN STYLE=3D'font-siz=
e:10pt'>I don&#8217;t think you need to hack anything. Go to the finder and =
right click a the pdf file. Check the open with option to make sure it point=
s to preview or Adobe reader or something other than WORD. You may have to r=
estart the machine after you do this to make sure Excel knows about the chan=
ge.<BR>
</SPAN></FONT><FONT SIZE=3D"2"><FONT FACE=3D"Verdana, Helvetica, Arial"><SPAN S=
TYLE=3D'font-size:9pt'><BR>
-- <BR>
Bob Greenblatt [MVP], Macintosh<BR>
bobgreenblattATmsnDOTcom</SPAN></FONT></FONT><FONT FACE=3D"Lucida Grande"><SP=
AN STYLE=3D'font-size:10pt'><BR>
</SPAN></FONT>
</BODY>
</HTML>


--B_3347886514_62943952--

0
Reply Bob 2/1/2010 9:28:34 PM


I've looked into this a little further. Other applications know to use Preview to open PDF's. It seems that the problem is limited to a small class of files. The PDF that prompted this post was created as  Word. When I try to open it from a document hyperlink in Excel, it uses Word to try to open it and fails. This is a bug. <br>
For other PDF's such as the ones I have produced with LaTeX, Excel uses Preview to open them. If I use Word to print to a PDF file, there is not a problem. The only trouble is with linking to PDF created in Word with Save As... <br>
In summary, Excel can't successfully link to a PDF created in Word with Save As... PDF. Print -> Save as PDF works just fine.
0
Reply tdi 2/1/2010 11:51:14 PM

I've not had an opportunity to test this, so I'll certainly take your word 
for it. If you're reasonably sure of your findings please use Help> Send 
Feedback to convey them to Microsoft.

Assuming we're able to confirm one of us will also submit a bug report. 
Otherwise we'll reply here with any differences encountered. Thanks for the 
info.

-- 
Regards |:>)
Bob Jones
[MVP] Office:Mac

<tdi@officeformac.com> wrote in message 
news:59bb20e0.1@webcrossing.JaKIaxP2ac0...
> I've looked into this a little further. Other applications know to use 
> Preview to open PDF's. It seems that the problem is limited to a small 
> class of files. The PDF that prompted this post was created as Word. When 
> I try to open it from a document hyperlink in Excel, it uses Word to try 
> to open it and fails. This is a bug.
> For other PDF's such as the ones I have produced with LaTeX, Excel uses 
> Preview to open them. If I use Word to print to a PDF file, there is not a 
> problem. The only trouble is with linking to PDF created in Word with Save 
> As...
> In summary, Excel can't successfully link to a PDF created in Word with 
> Save As... PDF. Print -> Save as PDF works just fine. 

0
Reply CyberTaz 2/2/2010 5:52:24 PM

Thanks for reporting this issue - we are investigating it. <br><br>Thanks,  <br>
XinXin Liu <br>
Macintosh Business Unit, Microsoft  <br><br>This posting is provided &quot;AS IS&quot; with no warranties, and confers no rights.  <br><br>> I've looked into this a little further. Other applications know to use Preview to open PDF's. It seems that the problem is limited to a small class of files. The PDF that prompted this post was created as  Word. When I try to open it from a document hyperlink in Excel, it uses Word to try to open it and fails. This is a bug. <br>
> For other PDF's such as the ones I have produced with LaTeX, Excel uses Preview to open them. If I use Word to print to a PDF file, there is not a problem. The only trouble is with linking to PDF created in Word with Save As... <br>
> In summary, Excel can't successfully link to a PDF created in Word with Save As... PDF. Print -> Save as PDF works just fine.
0
Reply XinXin 2/4/2010 11:59:00 AM

4 Replies
429 Views

(page loaded in 0.748 seconds)

Similiar Articles:
















7/22/2012 9:10:11 PM


Reply: