ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Refreshing external data breaks sorting of function columns (https://www.excelbanter.com/excel-discussion-misc-queries/112463-refreshing-external-data-breaks-sorting-function-columns.html)

BNick

Refreshing external data breaks sorting of function columns
 
Using Excel 2007 Beta 2 Technical Refresh

I have a 7-column table. The first 5 columns are imported/linked from an
Access databsse. The 6th column contains some constants (entered manually,
post-import); the last column contains functions.

Sorting works as expected until I refresh the data. Upon refresh, columns
1-5 preserve their sorting; columns 6 and 7 stick together, but get sorted
seemingly randomly. I don't recall having this problem in Excel 2003. Is
this a bug that somebody knows about, or am I missing something?


All times are GMT +1. The time now is 05:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com