Z
Zig Mandel
Appears to be an excel bug (using excel 2002)
Anyone know a workarround?
If I insert a database query using "New database query" and then later edit
the query (Edit Query context menu option on the query), and insert one more
column and re-order the columns (in Query Wizard: Choose Columns), the new
column order is NOT reflected in the speadsheet. Excel will force the newly
added column to go as the last column.
Any way to work-arround it? The columns are unlocked, if it matters.
Currently my workarround is to delete the inserted query and re-insert it
again. Sort of defeats the purpose of being able to edit the query, and is
very time-consuming.
Thanx,
Zig Mandel
Anyone know a workarround?
If I insert a database query using "New database query" and then later edit
the query (Edit Query context menu option on the query), and insert one more
column and re-order the columns (in Query Wizard: Choose Columns), the new
column order is NOT reflected in the speadsheet. Excel will force the newly
added column to go as the last column.
Any way to work-arround it? The columns are unlocked, if it matters.
Currently my workarround is to delete the inserted query and re-insert it
again. Sort of defeats the purpose of being able to edit the query, and is
very time-consuming.
Thanx,
Zig Mandel