Years ago on Excel 2007 I created a rather elaborate workbook for internal timekeeping for my office. It has 25 worksheets with 25 lines on each page and on each line is a pulldown listing specific things that can be billed. The user selects an item, enters a quantity in the next column, the sheet calculates total cost and allocates that cost to the correct expense type. It has worked great.

When we upgraded to the Office 2010 things started to go haywire.

The calculation part of it still works perfectly, but often, 'tho not always, when anyone prints a sheet all of the pulldown fields on the sheet shrink in size and move. The change is quite specific and repeatable. It shrinks the same amount and moves to the exact same place on the page.

I only print sheets on which data has been entered, so I don't know if data entry causes the problem, but the problem does not usually appear until I print the sheet.

I want to make it stop doing this. When it moves it covers up other data and moving it back where it goes requires that I resize each pulldown individually. When the office is busy I have to move and resize 3750 fields. It is a pain.

Here is a screen cap of the file as it opens and after it has reformated itself when printed.

As you can see it does not matter whether any of the pulldown fields have been used.

Just be clear the reformating is NOT just a printing error. The file is reformatted (CNTL+Z does not fix it) and, so far, I've only been able to fix it manually, after which it seems to stay fixed.



Any help will be appreciated.



JP