?
Solved

Viewing interactive Excel Web Pages

Posted on 2011-09-12
2
Medium Priority
?
301 Views
Last Modified: 2012-05-12
I have an Excel Spread Sheet (MS Excel 2003) that is saved as a web page and this Web Page contains a table with autofilters.  This table is opened via  a hyperlink in another Web Page.

My question is how do I open this Spread Sheet as a web page and still be able to use the filters to select the data view required?
0
Comment
Question by:DHPBilcare
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 16

Accepted Solution

by:
Bryan Butler earned 2000 total points
ID: 36525210
You probably have to embed it:

http://office.microsoft.com/en-us/excel/embed-an-excel-spreadsheet-on-a-web-page-FX102602478.aspx

I believe you can only "save as" a static type web page.
0
 
LVL 16

Assisted Solution

by:Bryan Butler
Bryan Butler earned 2000 total points
ID: 36525255
Or maybe use google docs which seems tricky:

http://www.google.com/support/forum/p/Google+Docs/thread?tid=134c781a134fbe99&hl=en

And here's something that might help:
http://www.taming-openoffice-org.com/newsite/?page_id=633

Also, a good discussion: (note the last comment about Office2007)
http://www.webdeveloper.com/forum/showthread.php?t=235126
0

Featured Post

Why Off-Site Backups Are The Only Way To Go

You are probably backing up your data—but how and where? Ransomware is on the rise and there are variants that specifically target backups. Read on to discover why off-site is the way to go.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question