Another strange thing is that although I have Excel 2007 as the default version Dynamo opens Excel in the 2003 version.
Anyways: I write Revit-room-element property data to cols 1-3. Col 4 returns the total area of each of several rooms types as defined in Col 2 (room type 1 or 2 or 3). If I open an existing sheet after closing the whole setup, say in the morning when I log on at the office, the sheet gets overwriten by Dynamo, not just cols 1-3. So, no formulas and no sheet based macros???
It does seem buggy especially the part where it opens a legacy version of Excel. Any thoughts would be appreciated.