Set the Excel Spreadsheet to pull from a remote data source using ODBC.
That gives the added security of allowing people to play with the data without changing the data in the database.
But you want them to be able to manipulate the data from Excel.
There is a spreadsheet interface metaphor. Parts of it are quite useful. Other parts are less convenient given the ways that people program/use spreadsheets. Some of them are better addressed with parts of the database metaphor.
Of course, if you want it to be successful, you need to be able to import Excel spreadsheets as is, including macros and formula, and you also may need to maintain the linking to/from other microsoft artifacts.