Viva_Excel
Board Regular
- Joined
- Nov 13, 2008
- Messages
- 89
Hello, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
I have a workbook that has a lot of tabs where several of the tabs have data that is grouped. I keep the grouping collapsed in the file so I don’t have to see all the detail. However, whenever need to link another workbook to the workbook with my grouped data, it opens the grouping when I link to the file. Does anyone know if there is a setting in Excel that I need to change so that it won’t open my grouped data whenever I link to a file?<o></o>
<o> </o>
Thanks!<o></o>
<o> </o>
I have a workbook that has a lot of tabs where several of the tabs have data that is grouped. I keep the grouping collapsed in the file so I don’t have to see all the detail. However, whenever need to link another workbook to the workbook with my grouped data, it opens the grouping when I link to the file. Does anyone know if there is a setting in Excel that I need to change so that it won’t open my grouped data whenever I link to a file?<o></o>
<o> </o>
Thanks!<o></o>