[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Opening a PDF File as Table in Spreadsheet

Posted on 2012-09-11
7
Medium Priority
?
349 Views
Last Modified: 2012-10-23
Hi Guys,

I have this problem whereby whenever i highlight a table in a PDF file and right click on it to open it as a table in spreadsheet, it would give me an error message 'Unexpected Error occurred while opening this table in spreadsheet.

Anyone can advise why this error occurs?

I am using Adobe Acrobat Pro 9 and MS Excel 2007. Below is the screenshot of the error.

Unexpected error
Please advise.

Thanks!
0
Comment
Question by:Gapseudo081
  • 4
  • 3
7 Comments
 
LVL 24

Expert Comment

by:Steve
ID: 38386389
It may be because of the headers (multiline / brackets)
Have you tried opening just the data without headers?
ie periods 1 to 12 only.
0
 

Author Comment

by:Gapseudo081
ID: 38389447
Hi The_Barman,

But however, when i save it to my desktop, i can open the table in spreadsheet with no problems.

Strange..
0
 
LVL 24

Expert Comment

by:Steve
ID: 38389984
Where are you opening it from when it is not working?
If you are opening it from an E-mail, it may be the temporary nature of the file as opened which is causing the issue.
Sounds like saving the file first is the solution.
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

Author Comment

by:Gapseudo081
ID: 38393519
The file is a pdf file posted on the website. I opened it by double-clicking on it and then it will open the pdf file in another browser window.
0
 
LVL 24

Expert Comment

by:Steve
ID: 38393805
right click the link, from the options there you should be able to 'save as' rather than opening.
Then can open from your save location.
0
 

Author Comment

by:Gapseudo081
ID: 38397463
Yes i know. However, it would be more convenient if i can get it to open in a Browser and then do the open table in spreadsheet.

I am just wondering am i missing anything. Since Adobe offers this functionality, it has gotta work somehow.

And like what you said, the workaround would be to save it before opening the table in spreadsheet.

Thanks!
0
 
LVL 24

Accepted Solution

by:
Steve earned 500 total points
ID: 38416895
Have you tried to set the default open method to Adobe rather than Browser, this may help:

1. Run the installed Adobe Reader.
2. Click on Edit in the menu bar.
3. Then click on Preferences in the drop down menu list.
4. Click on the Internet category on the left pane.
5. Uncheck and untick the check box for Display PDF in Browser.

This may change the behaviour of the file sufficiently to allow for your table download to work.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
MS Outlook undoubtedly is the most widely used email client.Its user-friendliness, cost effectiveness, and availability with Microsoft Office Suite make it the most popular email application.  Its compatibility with Microsoft applications like Exch…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question