Message: Ref not Valid. Must be to Open Worksheet

  • Thread starter Thread starter Glenn
  • Start date Start date
G

Glenn

Hello,

I've copied a chart into a new worksheet and then attempted to modify the
series data to point it to new data. When I try to make the change, I get
the message:
Reference not valid. Reference must be to an open worksheet.
I've looked at the worksheet and it is not protected. Can someone help me
understand how to make modifcations to this copied chart data?

Thank you
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart references when copying worksheets 3
Cannot copy worksheet to another file 2
Workbook linkage returns #REF! 4
Graphing data from multiple worksheets in same workbook 1
EXCEL FILTERS AND CHARTS 2
Formulae Ref Different Worksheets 1
chart with data source from multiple worksheets 2
Code to format cells on several worksheets 2

Back
Top