problem printing static images vs camera tool snapshots

Hi.

Here's my situation.  I have a workbook that has many tables on separate worksheets.  Then I have couple "summary" type of worksheets which contain camera tool snapshots of tables from different worksheets for easier viewing/printing.  Because of the heavy lag in recalculation time created by using camera tool snapshots, I have turned the snapshots into static images by removing the source range from their formula.  Instead, after making whatever changes I need in the data, I use a VBA macro to loop through each snapshot and briefly restore the source range formula so that it updates to reflect the latest table changes then clear the source range formula again, returning the snapshot to a static image.  This seems to work fine when I view the worksheets and makes the recalculation of the tables much faster when changing the data.

However, I have encountered a new problem.  If I print the summary worksheets with the static images, each table is printed as smaller than when they are snapshots.  In other words, when the source range formula is set to the appropriate range and I print the sheet, everything looks fine.  When I clear the source range formula and print the sheet, each table is now horizontally smaller and some information in the last column is being cut off.  The images/snapshots have their size set to 100% of the original and I have tried keeping "Relative to the original" checked and unchecked with no difference.  Does anyone know why this is happening?

February 8th, 2015 7:12pm

Is your overall worksheet zoom also at 100%? I've had multiple issues over the years with things resizing inappropriately when the worksheet itself was something other than 100%. In your case, that might mean both the source and destination sheets.

Are your tables dynamically changing column widths (based on changes to content)? Are the cutoff areas consistent with any changes to source range widths?

Perhaps you could give some specifics about how you set up the camera tool and/or your VBA, and maybe someone can provide alternatives. It seems like (instead of all that messing with formulas) that you could just use VBA to select a range, copy, and paste as picture (and resize the picture to the original's height and width, if appropriate)

Free Windows Admin Tool Kit Click here and download it now
February 9th, 2015 4:21pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics