Avoid sorting fields when update from external database

P

Peter

Hi.

I have a privottable in my Excel 2007. Data comes from a view in my
sql-database on a server.

When I connect or update the fields are shown in alfabetic order in
the pivottable, not in the order used in the source.

The order in the source-view is more logical for the users. Can I keep
that order in my pivottable ?

Regards

Peter
 

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

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Adding a pivot table in Excel 2007 from a QUERY in Access 2007 6
How do I stop a Pivot Table from Sorting my data (Excel 2007) 1
Can't create a report from my query in Access 1
Retrieving data in pivottable from Access / SQL server 3
Change the location of external data feeding a pivottable 4
Cannot update PivotTable Source Data when copy from other workbook 1
Pulling Data From PivotTable 1

Top