Prev: how do I set up an input calendar for users in excel
Next: How to change decimals of length in feet to feet and inchs
From: Nick on 23 Feb 2010 07:04
I'm inserting an object file (Pivot Chart) from a different workbook which
has many worksheets. When I locate the workbook in assigning the object it
will only insert the first worksheet tab of that workbook.
Is there a way to insert an object from the 3rd worksheet tab (as an
example; PivotChart3) instead of having to move the 3rd worksheet tab to the
front of the workbook, therefore making PivotChart3 the first worksheet?
This is what I'm currently doing as a workaround but it seems silly not to be
able to locate an object from one of the many worksheet tabs, surely there
must be a solution.
I have looked in the Microsoft Help guide which is pretty unhelpful to say
the least, therefore any assistance or advice would be gratefully received.
Many thanks in advance,