I have a web based database that I work with regularly that uses 802.1x authentication (Smart Card with password). From the website you can pull premade and custom reports that are ultimately stored in an SQL database and they are displayed on a webpage.
I want to use Excel 2007 to pull real time data from the database or website instead of copying and pasting the data into an Excel workbook everyday. Multiple users would log in on multiple computers to access the Excel document and the document would need to be located on a shared network resource.
Is there any sort of solution?
I'm sure more information is required, so please do not hesitate to ask.