• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Losing sheet reference in chart series

B

Brant

New Member
Hi All,


I've created a dashboard with a chart referencing dynamic named formulas on another sheet for its series values. I'm using excel 2007 (my first problem...), and when I open a copy of the workbook (after it's been emailed to someone for instance), the sheet reference in the chart series value box has changed from the sheet name to "[0]". For example, "Sheet1!NamedFormula" changes to "[0]!NamedFormula".


The macros I have assigned to my controls on the dashboard are also losing the workbook reference. Any idea on why this is happening or how to fix it?


Thanks!
 
Floor tiles are the strongest decorative material that is used in home construction. It comes in different shapes and sizes like square and rectangular.


The prime concern of home owners regarding floor tiles is of cleaning and maintaining a tiled floor. A majority of home owners assume that flooring material should be maintenance free. Today's lifestyle is very fast and this fast lifestyle leaves little or no time for the home owners to clean or maintain their home fixtures, floors, walls and various countertops.


Whatever cleaning work they can do in their homes is possible only on weekends. If you are home owner with no time for home cleaning then consider tiling your home floor
 
You must log in or register to reply here.
Back
Top