Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
If you can access the database through ODBC you could probably wire it up. But using a shared Excel document has it's own issues. A small web application would probably be the best bet. – Brad Patton Apr 12 '13 at 17:48
Kindly have a look at this link… – Santosh Apr 12 '13 at 19:35
OP here ^^I cannot access the database directly Brad Patton. ^Thank you for the informative link Santosh. My particular problem lies with the current active session that I have. Once my session expires (maybe 10 minutes or so) the website will no longer work unless I log in through the normal web browser and activate my session again and update all the queries through Excel. Then it works fine until the session expires again. – HBF Apr 13 '13 at 12:56

You must log in to answer this question.

Browse other questions tagged .