View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JohnBury JohnBury is offline
external usenet poster
 
Posts: 4
Default Opening html versions of workbooks

This is related to a post made earlier, but I do not feel I explained myself
clearly enough.

We use an Excel workbook template to document information about schemes of
work and lesson plans. These workbooks are 'filled' in and then converted to
'web content', i.e. processed by internal (passworded) macros and saved out
as a non interactive workbook in HTML.

Occasionally I need to update a cell in a small number of worksheets
contained within the workbook (changes to hyperlinks to external documents).

If I wish to edit the HTML, I open the files in excel, at which point Excel
seems to go through a process where all cells are (re) calculated.

As these workbooks are fairly large, this takes an age. Is there any way in
which I can edit these files without this recalculation?

regards

John
--
UK John