If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Multiple SQL Queries on one sheet
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? |
#2
|
|||
|
|||
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 -----Original Message----- 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? . |
#3
|
|||
|
|||
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. "jeff" wrote in message ... 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 -----Original Message----- 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? . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Efficient queries with SQL backend | wheeel_o | Running & Setting Up Queries | 1 | July 20th, 2004 02:38 AM |
Commenting SQL Queries | Kyle B. | General Discussion | 2 | July 16th, 2004 09:58 PM |
Multiple items on the same sheet | Erica | Setting up and Configuration | 1 | November 27th, 2003 08:39 PM |
Multiple charts in one sheet | Shovelman | Charts and Charting | 1 | October 12th, 2003 03:38 AM |