Why did the workbook save as a group?

S

sailjoe

I copied text, values and formulas from one workbook to another. When I
tried to chart some of the data, the chart insert chices were grayed out. It
appears the file was saved as file name [group]. How do I ungroup?
 
D

David Biddulph

It sounds as if you have grouped a number of sheets in the workbook. Right
click on one of the sheet tabs, & choose "Ungroup Sheets".
 

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

Save workbook without shapes 0
Save a custom chart as a template 0
Dynamic charts with named range Windows 8.1 0
Use a master workbook to carry over changes to multiple workbooks 1
Cannot Change Back to Previous Settings After Clicking "Try the new Outlook" 0
Active Content in this file is blocked issue 1
Excel 2003 dynamic named range for the values in a pie chart 1
Excel 2010 Data Labels options not saving 0

Top