Functioning spreadsheet on my web server

legalpro

New Member
Joined
Oct 9, 2006
Messages
1
I'm not very experienced with web design or excel but was wondering how difficult it would be to have a functioning spreadsheet on my website for clients.

Any instructions or advice on how to do this would be appreciated.
thanks.
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

tusharm

MrExcel MVP
Joined
May 28, 2002
Messages
11,029
I don't know anything about the suggestions you've received; if you try them out maybe you can post your experience with them.

You can also look at MS's Office Web Components, which are packaged with Office 2002 and 2003 (and maybe with 2000).

Using XL (or other legacy Office apps) on the server is a big no-no. See http://support.microsoft.com/default.aspx?scid=kb;en-us;Q257757
I'm not very experienced with web design or excel but was wondering how difficult it would be to have a functioning spreadsheet on my website for clients.

Any instructions or advice on how to do this would be appreciated.
thanks.
 

cheveley

Active Member
Joined
Sep 24, 2002
Messages
273

ADVERTISEMENT

would the products i mentioned side step the issue of using xl on the server tusharm?
 

tusharm

MrExcel MVP
Joined
May 28, 2002
Messages
11,029
My understanding is that those products convert the XL workbook/sheet into a web-compatible "application." Think of it as a souped-up version of Colo's HTML Maker. Or, maybe, Google's online spreadsheet.

I imagine that for those who must make their XL apps "web friendly" these types of programs play an useful role.

At the same time, since they are converters, it leads to several obvious questions. And, I don't pretend to know the answers.

How well do they mimic the XL environment? For example, can they handle references to the contents of other worksheets? Workbooks? How well do they handle named ranges, named formulas?

Do they support MS-supplied addins such as the ATP or Solver? Do they handle UDFs? Other types of macros? Event procedures?

Also, several XL functions have long-standing "issues" with them, some by design, others by accident. How do these converter apps handle them? Do they mimic the problem?

MS has introduced differences in functionality with different versions of XL. For example, several stats functions were changed in 2002 and 2003. How do the converter programs handle this?

Again, this is not meant to criticize the converter type programs. The above is a non-exhaustive list of some of the concerns that I have had when evaluating such programs in the past and would have if I were to evaluate one in the future.

would the products i mentioned side step the issue of using xl on the server tusharm?
 

cheveley

Active Member
Joined
Sep 24, 2002
Messages
273
thanks. i am at crossroads with regards to development. have spent 7 months building a web-based application using excel on the server as a solution. this is no solution as speed is slow and there is no scalability whatsover (everything has to be qued).

wonder whether to convert using above mentioned programs or convert our excel program into another language.

i will update on any success and failures!
 

tusharm

MrExcel MVP
Joined
May 28, 2002
Messages
11,029
Office 2007 introduces something called the Excel Server. But, beyond knowing it's name, I don't know anything about it.

thanks. i am at crossroads with regards to development. have spent 7 months building a web-based application using excel on the server as a solution. this is no solution as speed is slow and there is no scalability whatsover (everything has to be qued).

wonder whether to convert using above mentioned programs or convert our excel program into another language.

i will update on any success and failures!
 

Forum statistics

Threads
1,136,619
Messages
5,676,847
Members
419,655
Latest member
pd2021vb

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