Jun 07 2020 02:40 AM
Jun 07 2020 05:10 AM
I could be mistaken about this, but I've never seen that option and doubt that it's available. I have seen situations where people have written small programs to extract data from PDF files. But not a simple option in the Get Data menu.
For one thing, PDF files can take multiple forms, one of which is to be a simple image of a page of text, which generally isn't even searchable. Even PDF that consists of a searchable/editable text can be tricky. I have found, in one-off situations, that I can use Copy and Paste to take data from a PDF page where it appears as a table and paste it into Excel......so you might try that.
I'm happy to be corrected, if there are others here who know better about this topic.
Jun 07 2020 05:50 AM - edited Jun 07 2020 05:54 AM
@Rui_Coelho Have a look at this link:
Scroll down a bit until you see this:
If you are on this version (or later), you should find it here:
By the way: Windows only!!
Jun 08 2020 07:27 AM - edited Jun 08 2020 07:29 AM
Something to consider, I agree.
In general, I'm more than satisfied with what I get in the Mac environment in Excel....especially for my personal needs and what little "advising" I do for others. If I end up getting significantly deeper into things with more people, I may do that. Might even get an inexpensive Windows laptop. I'll leave the true power users to you and the other MVPs.
I actually have a few other interests that, in the grand scheme of things, exceed Excel in importance. Believe it or not. Maybe not in fun, but in importance.
Nov 25 2020 02:11 AM
You can update to Windows 10 with your W7 key.
So you can get 365 on the version as Mr. Riny_van_Eekelen has described.
If you update to Windows 10 you should also update your PC to at least 8GB RAM and hard drive on SSD, otherwise it will slow down your PC.
Or you can download a "preliminary" converter software (which I don't recommend),
many problems could arise.
Files without sensitive data could also be converted online for the time being if this is absolutely necessary.
Here is a link: https://online2pdf.com/en/
As already said, there are many ways in Excel that could lead to a solution, but tailor-made solutions sometimes come with additional costs.
I hope I could help you a little bit further in your project.
I know I don't know anything (Socrates)
Nov 25 2020 11:47 AM
In my humble opinion, I can say that it makes a huge difference.
I do hardware updates in four-digit range each year and the difference is significant.
SSD hard drive, more GB of RAM and BIOS with the latest updates really make a huge difference.
In all our office world, we must not forget that many users do not have huge computer power (motherboard, video card, etc.) or the latest processor.
I agree with you that it may be that if you only compare Office before and Office after that the difference is not that significant.
But, if we are honest with ourselves, which user measures according to such standards?
A user measures from the start of his PC until the worksheet appears, before and after.
He does not need a measuring device, he can see the difference with the bare eye.
In some cases (I would rather not name a PC company) it is like day and night.
It is obvious that it is not the office alone, but it makes a huge difference, even for the office,
when the user feels like switching from bicycle to motorcycle.
We should always keep in mind that Office does not live alone in our PC. Office is a part of our PC world, for some a very small part.
Anyway, that's my opinion and my experience ... but what are they worth? ... Because I and everyone else know that I don't know anything, and yet in some cases that can be a lot.
Thank you for taking the time to read my comment so far.
I wish you a pleasant evening
I know I don't know anything (Socrates)
Nov 27 2020 09:06 AM
Feb 18 2021 09:58 PM
@Kejing_Gu1220 Please see the attached article. Towards the end of it you'll find some fairly recent comments from people asking why they can't see the PDF Connector. From your picture it looks like you are not an MS365 subscriber.