Publishing Interactive Excel to the Web

mintconsult

New Member
Joined
Oct 8, 2009
Messages
5
Hi all,

I have the need to publish an excel page or pages to the web through my website. Whilst having a static frame is straight forward, I am hoping to include the original functionality from the sheet. i.e. using the pivot table and pivot charts. I have spent hours searching for the solution, without success - any help would bge greatly appreciated.

Thanks, Mark
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

mintconsult

New Member
Joined
Oct 8, 2009
Messages
5
Thanks Andrew.

I think it has changed on 2007 and 2010. From what I read in the early hours this morning, it seems Microsoft ruined what was a good feature in 2003.

If only I had an old copy of 2003 kicking about....

Thanks, Mark
 

mintconsult

New Member
Joined
Oct 8, 2009
Messages
5

ADVERTISEMENT

Hi Andrew

Thankis again - unfortunately when doing it this way it loses the interactivity of the sheet, such that drop down boxes disappear and graphs do not display correctly. There must be a way, its just finding it. I am now experimenting with Windows Live SkyDrive (unsuccessfully).

Thanks, Mark
 

wdemilly

New Member
Joined
Oct 9, 2011
Messages
3
Mark hi,

I need to do the same thing. Mr. Excel has some youtube videos which describe the process of an interactive excel website, which uses skydrive.

I remember watching the vid a few weeks ago but can't find it. In any case some youtube searching should help. If I discover, I'll post the links here.
 

mintconsult

New Member
Joined
Oct 8, 2009
Messages
5
Hey, thanks for this. Think I will be experimenting with it shortly - looks excellent and just what I wanted.

Thanks, Mark
 

wdemilly

New Member
Joined
Oct 9, 2011
Messages
3
Mark great. Would you do a favor and let us know how it goes? I want to publish an online "what-if" calculator. The calculator will look very simple to the website user, but the workbook itself involves many complex formulas and lots of data to crunch. So I'm concerned about the speed.

Once I get mine up I'll also post my experiences.

Thanks
 

aidasa

New Member
Joined
Jun 9, 2014
Messages
19
Mark great. Would you do a favor and let us know how it goes? I want to publish an online "what-if" calculator. The calculator will look very simple to the website user, but the workbook itself involves many complex formulas and lots of data to crunch. So I'm concerned about the speed.

Once I get mine up I'll also post my experiences.

Thanks



Dear All,
Did anyone found an answer re this topic?

Many thanks!
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,434
Messages
5,837,222
Members
430,485
Latest member
DavevonD

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top