Excel doc on web server
I have a link from ASP to an Excel spreadsheet. In the spreadsheet, I'm using External data linked to a DSN. The problem is that I want Excel to use the DSN that is set up on the web server. I thought that it would do this because I'm linking to the Excel doc from the web server.
However, it only works if the DSN is created on the client machine.