Quote:
Originally Posted by brizzad
Really? That's awesome. Do only the newer versions of excel utilize this feature?
|
I have no idea...lol. Know it works in 97 and 2000.
It came up when we were trying to get our server admin to install excel on the server so we could odbc to excel to write reports. He was very resistant, so we found a way around him.
It is a simple little trick but makes a lot of stuff easier to do once you play with it for a bit.
I haven't figured out how to do multiple page workbooks yet but the single page trick saves a lot of exporting and importing data when you need a quick little report.
I don't think it actually converts the data to an excel sheet. It keeps it in html but it allows you to navigate it and all that in excel.