Excel BOM too big to see when editing

Hi all:

Using SW2006 SP5 under WXP. When editing an existing assembly drawing
with an Excel BOM inserted, sometimes I get the following strange
behavior. I double-click (or right-click and choose edit) the BOM to
edit it, and the Excel window that pops up is so large that it doesn't
fit on the screen. There is no way that I can find to scroll, zoom,
or otherwise see more than the first couple of rows and columns in the
table. I've tried restarting SolidWorks, and restarting Windows, but
this made no difference. The problem only happens occasionally, but
is persistant with a given drawing. Once it happens, it always
happens. The only solution I have found is to delete the BOM and re-
insert it. However, this also deletes the other information that I
have added manually. Is there another way to go about this? Any help
would be appreciated.

Regards,
John.

 

Hi John,

While I don't use an Excel BOM, I do have an embedded WKS in my
development drawing for the calcs used to validate flat patterns. If I
copy the WKS for secondary profile proofing, it blows up as you
describe. What I am forced to do is right click, select properties and
then set the scale to .5. This sets the WKS to something I can fit on
the page, but I still have to open it and tweak a column width before
it scales properly.

Hope that helps.