Publishing an Excel spreadsheet using Microsoft SBS 2008 to a web page that is viewable by mobile ph
- by Dave Heath
I am getting well out of my “superuser” depth here and would love some support.
At work we have an Excel workbook (*.xls format circa Office 2003) which maintains our “engineers” timesheet. This handles what events we are doing across the year and how many “work units” it is.
As far as a workbook goes, it is fairly simple with just a few =SUM(range) cells and some linked across sheets (12 sheets, one for each month)
It is stored on a server, in a folder that provides “management” with full access and “engineers” with read-only access.
The workbook itself is read-only for “engineers” and full access for “management”. I think these permissions are controlled through Active Directory.
The workbook is protected with a password, assumingly to allow “management” to edit it even if they are working at a terminal logged in as an “engineer”. This protection prevents “engineers” from going to certain cells to see formulae and therefore editing them.
The workbook has a macro which saves and closes it ten minutes after opening. This is to stop other “management” from being locked out by any one person who has logged in with editing privileges.
I hope this is making sense to someone... :S
Now then, we have Microsoft Small Business Server 2008. We have a shiny new web-based login for when we are offsite so we can get to Exchange webmail and our internal site (which uses Sharepoint 3.0).
“Management” would like to be able to publish this timesheet automatically after changes (they don’t want to have to do anything different to what they are currently doing) so that using an iPhone “engineers” can check on it while out of the office.
I am currently having a look at “Excel Services” for Office 2007 on TechNet but I am not sure if I am running down the right garden path at the moment.
< EDIT
This seems to suggest that I have to have Sharepoint Server 2007, with no mention of Sharepoint 3.0...
... "MOSS builds on WSS by adding both core features as well as end user web parts" - Wikipedia entry for Microsoft Office SharePoint Server (MOSS) this is not good news...
"...and using the ASP.NET APIs, web parts can be written to extend the functionality of WSS." Wikipedia entry for Windows Sharepoint Services. Could this bring back what I need? Is this good news? Do I need to start learning ASP.NET?
This link here implies that we need MOSS to do what I want and the bosses say we aint' getting it.
http://serverfault.com/questions/20198/what-is-some-cool-things-you-can-do-with-sharepoint-2007/22128#22128
Back to the drawing board.
< /EDIT
Please could someone suggest some “further reading” for me to help point me in the right direction or to put me back on the right track.
Many thanks. I will try to keep this up to date with how I get on.
