Multiple SQL Queries on one sheet

K

Kevin

I am editing the last SQL query on a sheet that has 5 queries on it.
I am adding a column. Excel is insisting on shifting columns for the
queries above over, leaving blank columns. I do not have this problem
if I start with a blank sheet and add the queries from scratch.

Anybody know how to turn off this behaviour?

P.S. - Unrelated, but how in the heck do I change the datasource for
an existing query?
 
J

jeff

Hi,

Q2. Goto control panel, administrative tools, datasources

Q1. I think if you right-click your query cell, select
Data range properties..., and in that box look at the
formatting section; I always have "preserver column..
layout" and "Preserve cell format" only checked; along
with "Overwrite existing cells..." in the bottom section.

Try taking a look at these.

jeff
 
K

Kevin

Sorry, I should have been more specific. I know how to edit a
datasource - I want to change the query to use a different datasource
- there seems no way to change it. I created a huge spreadsheet using
one datasoucre name, but the users have a difference datasource name
already defined. I don't want to redo 75 queries, but I don't want to
set up a new datasource on 75 computers either.

I have tried many different combinations of the datarange properties,
but one spreadsheet page with 5 or 6 queries gives me many problems
when I change the columns in any of them.
 
Top