1 of 1 people found this helpful
The only way I know of is to create the table view you want, then control A, control V into Excel. View data always rearranges the columns.
Thanks. I've created a table view (actually looks better than my original raw format!), and now I'm ready to move out to excel. I tried control A, control V, and nothing. I don't know what control A is suppose to do?
I tried control C, control V in Excel, and get most of the data, but it was reformatted again.
My end goal is to allow sales agents to work from this list of prioritized cross-sell opportunities. There has to be a way to get this to them. I'm open to other suggestions.
The original post says this has not yet been answered and I am having the same problem. I can't understand how to resolve this. If this is a known issue, I may have to look to MS access to help. And that just isn't right.
What about exporting the worksheet as a crosstab? Go to Worksheet on the main menu>Export>Crosstab to Excel.
Hope this helps!
Tracy - interesting idea and will test.
What about a solution for a published workbook?