Can Excel be use to a limited degree without the full program

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Doug Sanders - 28 May 2007 05:05 GMT

Can an Excel spreadsheet be distributed that allows only limited values be
changed, not formulas, to users without Excel?

Sort of mortgage amortization tables, etc. as example.

User can plug in some numbers, see results, but can not change the core
algorithms.

If s, how would this be done?

Thanks,

Doug Sanders

Reply to this Message

Nick Hodge - 28 May 2007 10:21 GMT

Doug

You can download the Excel viewer from here

http://www.microsoft.com/downloads/details.aspx?FamilyID=c8378bf4-996c-4569-b547
-75edbd03aaf0&displaylang=EN

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/

> Can an Excel spreadsheet be distributed that allows only limited values be
> changed, not formulas, to users without Excel?
[quoted text clipped - 9 lines]
>
> Doug Sanders

Reply to this Message

Gordon - 28 May 2007 13:40 GMT

> Can an Excel spreadsheet be distributed that allows only limited values be
> changed, not formulas, to users without Excel?
[quoted text clipped - 9 lines]
>
> Doug Sanders

No in a word. To change anything in a spreadsheet, the user needs to have an
application capable of opening and editing it, and the only applications
that will do that are full Excel-compatable spreadsheet programs. The
viewer, as recommended by another poster, only allows (afaik) just that,
viewing. The viewer CANNOT change anything.

Reply to this Message

Gord Dibben - 28 May 2007 21:33 GMT

Gordon

Been a while since I used the viewer, but I believe the users can make changes
and play what-if when opened in the Viewer.

Just can't save the changes.

Gord Dibben MS Excel MVP

>No in a word. To change anything in a spreadsheet, the user needs to have an
>application capable of opening and editing it, and the only applications
>that will do that are full Excel-compatable spreadsheet programs. The
>viewer, as recommended by another poster, only allows (afaik) just that,
>viewing. The viewer CANNOT change anything.

Reply to this Message

Gordon - 29 May 2007 10:40 GMT

> Gordon
>
[quoted text clipped - 3 lines]
>
> Just can't save the changes.

Thanks for that info - I've never used the Viewer!

Reply to this Message

Doug Sanders - 29 May 2007 04:27 GMT

I'll try the viewer and see what it can do.

Thanks

Doug Sanders

> Can an Excel spreadsheet be distributed that allows only limited values be
> changed, not formulas, to users without Excel?
[quoted text clipped - 9 lines]
>
> Doug Sanders

Reply to this Message

Kate G. - 30 May 2007 02:24 GMT

Remember that in Microsoft Word you can insert a Microsoft Excel worksheet
that requires double clicking to "get into".

But once into it, you have full Excel functionality. So you could set up
your worksheet... then use the protection feature so that only the cells you
wish folks to have access to... can be accessed and changed.

Not sure if that will help or not... but another idea anyway.

Signature

Kathryn Groves

> Can an Excel spreadsheet be distributed that allows only limited values be
> changed, not formulas, to users without Excel?
[quoted text clipped - 9 lines]
>
> Doug Sanders

Reply to this Message

JLatham - 02 Jun 2007 02:00 GMT

But that implies that Excel is available on the recipient's system. When you
embed an object (as the Excel workbook within the Word document) the object
is inoperative unless the creating application is available. The actual
Excel application does not get embedded into the document along with the
workbook - the basic core of Excel 2007 is 16.8MB in size, for Excel 2003
it's 9+MB. Files of that size won't even make it through most email systems
these days.

Since the OP has said they don't have Excel, it's back to the Viewer for a
solution. Another drawback might be that if they don't have Excel they very
well may not have Word either, since both Word and Excel are contained in all
versions of Office. Although they could have Word as a stand alone
application or as part of the Works suite.

> Remember that in Microsoft Word you can insert a Microsoft Excel worksheet
> that requires double clicking to "get into".
[quoted text clipped - 18 lines]
> >
> > Doug Sanders

Reply to this Message