I want to export a list from sharepoint into excel. I can do this export easy with an iqy file. Once I have this iqy file (which by default is saved in my temporary area but I will save it to my desktop) I then link it into excel.
Now i have this list, I want to do a few modifications and then send it to some people, this is where the problem starts. If i send this file as it is, the link will break as the link is on my computer. So I want to host this IQY file somewhere accessible to the people I want to send it to. The people I want to send it to do not have access to one specific area other than the sharepoint. I want to host the file on the sharepoint and link it up to the Excel table but when I do this, it appears as though excel downloads a personal copy and links it to my excel again re-creating the original problem.
Is there any way in which I can host the IQY file on sharepoint and link to it? Or connecting to a sharepoint list WITHOUT using the iqy file?
Thanks in advanced! Sharepoint Version: 2007 Microsoft Office: 2010