Importing PDF data into Excel - With No Link back to the Data

%3CLINGO-SUB%20id%3D%22lingo-sub-1928869%22%20slang%3D%22en-US%22%3EImporting%20PDF%20data%20into%20Excel%20-%20With%20No%20Link%20back%20to%20the%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1928869%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Everyone%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOn%20a%20regular%20basis%2C%20I%20import%20data%20from%20PDF%20documents%20using%20PowerQuery.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20PDF%20data%20is%20not%20dynamic%2C%20it%20will%20not%20change%2C%20so%20I%20do%20not%20need%20the%20link%20back%20to%20the%20data%20in%20order%20for%20it%20to%20refresh.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20way%20I%20can%20import%20the%20data%20from%20my%20PDF%20file%20and%20not%20end%20up%20with%20a%20redundant%20link%20back%20to%20the%20data%3F%26nbsp%3B%20I%20am%20aware%20that%20I%20am%20able%20to%20delete%20the%20link%20manually%2C%20I%20would%20just%26nbsp%3B%3CSPAN%3Elike%20it%20if%20I%20could%20import%20the%20data%20into%20the%20spreadsheet.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EAny%20help%20or%20suggestions%20would%20be%20gratefully%20received.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EMany%20thanks%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EKeith%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1928869%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1929451%22%20slang%3D%22en-US%22%3ERe%3A%20Importing%20PDF%20data%20into%20Excel%20-%20With%20No%20Link%20back%20to%20the%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1929451%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F59521%22%20target%3D%22_blank%22%3E%40Keith%20Farmery%3C%2FA%3E%26nbsp%3BTowards%20the%20end%20(%22Advance%20refresh%20options%22)%20of%20the%20attached%20article%20%2C%20you%20can%20read%20how%20to%20set%20individual%20queries'%20behaviour%20regarding%20regarding%20Refresh.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fexceloffthegrid.com%2Fpower-query-data-refresh%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexceloffthegrid.com%2Fpower-query-data-refresh%2F%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi Everyone

 

On a regular basis, I import data from PDF documents using PowerQuery.

 

The PDF data is not dynamic, it will not change, so I do not need the link back to the data in order for it to refresh.

 

Is there any way I can import the data from my PDF file and not end up with a redundant link back to the data?  I am aware that I am able to delete the link manually, I would just like it if I could import the data into the spreadsheet.

 

Any help or suggestions would be gratefully received.

 

Many thanks

 

Keith

1 Reply

@Keith Farmery Towards the end ("Advance refresh options") of the attached article , you can read how to set individual queries' behaviour regarding regarding Refresh.

https://exceloffthegrid.com/power-query-data-refresh/