Sharepoint Excel Query table produces different links

%3CLINGO-SUB%20id%3D%22lingo-sub-1683913%22%20slang%3D%22en-US%22%3ESharepoint%20Excel%20Query%20table%20produces%20different%20links%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1683913%22%20slang%3D%22en-US%22%3E%3CP%3ESo%20I%20use%20an%20excel%20sharepoint%20query%20table%20to%20produce%20a%20document%20list%20that%20I%20then%20export%20to%20pdf%20using%20a%20macro.%20All%20the%20links%20to%20documents%20in%20the%20table%20are%20still%20active%20in%20the%20pdf.%20The%20issue%20is%20that%20when%20I%20export%20the%20table%20as%20pdf%20with%20the%20macro%20(which%20does%20a%20whole%20load%20of%20formatting%20stuff%20as%20well)%20all%20the%20links%20are%20to%20the%20files%20held%20on%20sharepoint%20but%20when%20I%20export%20using%20the%20export%20command%20without%20the%20macro%20the%20links%20in%20the%20pdf%20become%20links%20to%20the%20sync'd%20versions%20of%20the%20documents%20on%20my%20local%20machine%20not%20the%20sharepoint%20versions%20so%20nobody%20else%20can%20access%20those%20links.%20The%20links%20in%20the%20excel%20table%20are%20still%20to%20sharepoint%20versions%20but%20links%20in%20pdf%20are%20to%20local%20versions.%3C%2FP%3E%3CP%3EI%20have%20tried%20to%20use%20a%20dedicated%20export%20macro%20rather%20than%20my%20usual%20one%20but%20this%20does%20the%20same%20thing.%20Logic%20would%20suggest%20that%20there%20is%20something%20else%20in%20the%20fornatting%20macro%20which%20prevents%20this%20happening%20but%20I%20can't%20see%20what.%20Macros%20and%20sharepoint%20don't%20play%20very%20well%20together.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1683913%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

So I use an excel sharepoint query table to produce a document list that I then export to pdf using a macro. All the links to documents in the table are still active in the pdf. The issue is that when I export the table as pdf with the macro (which does a whole load of formatting stuff as well) all the links are to the files held on sharepoint but when I export using the export command without the macro the links in the pdf become links to the sync'd versions of the documents on my local machine not the sharepoint versions so nobody else can access those links. The links in the excel table are still to sharepoint versions but links in pdf are to local versions.

I have tried to use a dedicated export macro rather than my usual one but this does the same thing. Logic would suggest that there is something else in the fornatting macro which prevents this happening but I can't see what. Macros and sharepoint don't play very well together.

0 Replies