Non-technical users have been using Excel to update certain intranet pages with information contained within textboxes, a simple enough task in Excel 2000/2003. Unfortunately, Excel 2007 saves the textboxes as gifs, which then makes them uneditable and means the whole entry has to be retyped when an update is required.

Is it possible to prevent Excel 2007 from converting text-boxes to gifs when saving as .htm? Or can anyone recommend a better suggestion for non-technical users to update an intranet page? Longer-term, a move to a CMS to ease editing for non-technical users is on the cards but for now...

Alternatives ruled out:

Teaching the users in question to edit html isn't going to fly, and the application needs to be available on whatever PC they happen to be using across offices, hence the use of Office apps.

I've tried replicating the page in Word 2007, which introduced its own problem (Word 2007 appears to have a major issue over positioning the text boxes, making the position absolute when it should be relative and stacking them all on the extreme left of the page when viewed in a browser).

Saving the updates to xlsx to keep them editable and then saving again as htm is about the best idea I can come up with, but I can the saving as xlsx step getting missed on occasion, and as multiple users edit the same page, this is likely to lead to lost updates.

link|improve this question
1  
How about a macro that saves it as html where you want it. User opens xlsx (and always/only xlsx) and makes whatever changes. Then clicks a big button that says "post changes to intranet". Would that help prevent someone from forgetting to save as xlsx. – dkusleika Mar 10 '10 at 22:57
That's not bad idea, cheers, I'll have a look at that. – Bonus Mar 11 '10 at 14:46
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown

Browse other questions tagged or ask your own question.