I have users that are reporting that up until a couple weeks ago, they were able to import data from a pdf from this menu. That feature is now missing. We have licensing: So, why would this feature be missing?

Hi Raphael1175 For Excel version, channel... Within Excel: go to File > Account, on the right side - i.e.: The From File > From PDF option (in Excel User Interface) isn't available in all versions of Excel & Channels (no idea for Excel 2019 Home & Student). Such option allows users to easily do something (through a wizard) that could be +/- complex otherwise However, it's not because the option doesn't appear in the Excel User Interface that don't have access to the corresponding Power Query function (Pdf.Tables). To check this on your version of Excel:- Download the attached file & open it- In Sheet1 rigth-click on the following Table- Select the Refresh optionOnce the Refresh is complete, search in that Table for Pdf.Tables. If you find that occurence it means your version of Excel can import Tables from PDF files If you have Pdf.Tables function let us know and someone will explain how to use it...

trobinson-q2 One more picture is missing - on which channel you are. It looks like

SergeiBaklan I've tried updating Office/Excel, but it says we're up to date.

trobinson-q2 You are on semi-annual channel which is updated with new functionality twice per year, in Jan in Jul. Monthly Enterprise channel was updated with PDF connector in Oct 2020 Release notes for Monthly Enterprise Channel releases in 2020 - Office release notes | Microsoft Docs , semi-annual shall be updated few months later and I didn't find PDF connector in Jan update for that channel Release notes for Semi-Annual Enterprise Channel releases in 2020 - Office release notes | Microsoft Docs Thus you shall wait till July or upgrade on Monthly Enterprise or Current channels. That's free of charge and above channels are stable enough. However, which channel to use depends mostly on your organization ITS policies, are they ready to provide more or less new functionality to end users or prefer to wait couple of years till all possible fixes will be deployed.

SergeiBaklan Ok, that's good knowledge to have. Thank you for the response. However, it doesn't tell me why my users are saying that had this feature and then it was gone. Was it a feature Microsoft had to remove and now they're getting it back? I've had 3 user all start yelling at me, asking why this function is suddenly missing. EDIT: I also checked with our programmer. He has a home Office 365 yearly subscription and has the Get Data From PDF feature. Are the home versions different again?

Excel - Get Data from PDF is Missing | Microsoft Community Hub

SergeiBaklan
MVP
Feb 04, 2021
trobinson-q2

One more picture is missing - on which channel you are. It looks like
- trobinson-q2
  Copper Contributor
  Feb 04, 2021
  SergeiBaklan
  
  I've tried updating Office/Excel, but it says we're up to date.
  - SergeiBaklan
    MVP
    Feb 04, 2021
    trobinson-q2
    
    You are on semi-annual channel which is updated with new functionality twice per year, in Jan in Jul. Monthly Enterprise channel was updated with PDF connector in Oct 2020 Release notes for Monthly Enterprise Channel releases in 2020 - Office release notes | Microsoft Docs , semi-annual shall be updated few months later and I didn't find PDF connector in Jan update for that channel Release notes for Semi-Annual Enterprise Channel releases in 2020 - Office release notes | Microsoft Docs
    
    Thus you shall wait till July or upgrade on Monthly Enterprise or Current channels. That's free of charge and above channels are stable enough. However, which channel to use depends mostly on your organization ITS policies, are they ready to provide more or less new functionality to end users or prefer to wait couple of years till all possible fixes will be deployed.
inurmah
Copper Contributor
Sep 22, 2023
I also get the same issue---just found out now right when I need to work on something. Still looking for solution online.. would be great help to see some update from anyone here. trobinson-q2

Forum Discussion

Excel - Get Data from PDF is Missing

Share

Resources