I've had some problems with BOMs in SW2004 (SP2.1). A re-install of Office 97 seemed to cure some of them, but I'm not sure if the installation is working correctly. I can generate an XLS BOM without error now, but when I double click it to launch Excel within SW, the Excel toolbars and menus seem different. Specifically, the File menu does not have a Save or Print option. The Save toolbar icon is grayed out, and while the Print icon is accessible, it will not print.
Doing a "Save as XLS" lets me bring up the same BOM in a session of Excel launched outside SW. In this case the missing menu and toolbar items are visible and functional.
It has been several months since I generated a BOM, so I don't remember details of the Excel interface within SW. If anyone out there has Excel
97, would you see if the missing menu and toolbar items are functional for the SW-launched Excel? If not then it looks like SW intentionally disables some Excel functions.Thanks,
Art Woodbury