My company just upgraded to Excel 2007. I have many workbooks saved as htm that contain formulas and charts. I use VBA to update data in these which therefore updates the formulas and the charts. Using 2007, all my formulas are changed to constants and the charts are now pictures (OLE objects) upon saving as htm. Is there anyway around this? Thanks in advance.