shafiq_eng
New Member
- Joined
- Oct 6, 2004
- Messages
- 36
hi,
I have embedded charts which use dynamic named ranges for auto updating. Few days ago I observed that those are not updating and those ranges in charts have changed to [0]!RM_RHR_G like name. Instead of sheet or workbook name these are showing [0] value. All ranges have workbook scope. I have not changed sheet or workbook name. When I change those manullay updating takes place. but when after saving I reopen that workbook All my work changes bck to [0]!. please help.
shafiq
I have embedded charts which use dynamic named ranges for auto updating. Few days ago I observed that those are not updating and those ranges in charts have changed to [0]!RM_RHR_G like name. Instead of sheet or workbook name these are showing [0] value. All ranges have workbook scope. I have not changed sheet or workbook name. When I change those manullay updating takes place. but when after saving I reopen that workbook All my work changes bck to [0]!. please help.
shafiq