Jump to content

Welcome to Geeks to Go - Register now for FREE

Need help with your computer or device? Want to learn new tech skills? You're in the right place!
Geeks to Go is a friendly community of tech experts who can solve any problem you have. Just create a free account and post your question. Our volunteers will reply quickly and guide you through the steps. Don't let tech troubles stop you. Join Geeks to Go now and get the support you need!

How it Works Create Account
Photo

Excel spreadsheet on web page


  • Please log in to reply

#1
snowfly

snowfly

    New Member

  • Member
  • Pip
  • 1 posts
I operate a SQL server database consisting of several tables of which some have between 3 and 4 million records. Reports from this database are available to users throughout the country through accessing a secure website. Currently, these reports are created as Crystal reports. However, I am looking at a solution whereby I can create the reports in Excel (I am more interested in functional reports than in 'pretty' reports) and embed these reports as pivot tables or other spreadsheets on the website.

I know I can save an excel spreadsheet as a web page and upload such spreadsheets on the website. However, I am being told that because of the underlying data of the spreadsheet being quite large, it will take the users ages to open the spreadsheets on the website.

Is this really the case? Are there some techniques that I can apply to reduce the opening time of these spreadsheet/pivot tables very significantly? Or are there any other solutions or software that will make it possible for me to add these spreadsheets/pivot tables to the web site effectively/efficiciently?

Thanks for any suggestions.
  • 0

Advertisements







Similar Topics

1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP