Hi.

Background: I recently got a new computer that has Office/Excel 2010 on it instead of Excel 2007 which is what I was using before. I have an excel document that was created using 2007. On the sheets in that workbook, I use the camera tool to take a snapshot of a part of the sheet (which is a sports schedule) so that I can print that schedule on other sheets. For example, each sheet is the schedule for a certain team and then on other sheets I display the schedules for two different teams that play on the same night.

Ok, so the problem is that when I use Excel 2010 and open up the workbook, I am getting some strange behavior with the snapshots. The first problem is that if I change the schedule which is the source of a snapshot, the actual snapshot itself doesn't update unless I close and reopen the workbook. Is there some kind of option I need to set to get it to automatically update?

The second problem is that the snapshot is somehow using a different/bigger font than the original table/source of the snapshot. When I open the same document in 2007, it tells me that the snapshot image is 100% relative to the original size. When I open it in 2010, it tells me that the snapshot is 94% relative to the original. And the text isn't fitting in the columns in the snapshot because of the bigger font. Anyone know why that's happening?