Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
DrLostinExcel
 
Posts: n/a
Default stop excel from shifting cells up when a query returns no data

1. I am trying to create a Powerpoint Presentation from an Excel sheet which
is linked to a MS-SQL database. When the queries return no data Excel will
shift the cells where the data should go up on the sheet throwing off the
links to the charts. This is UNBELIEVEABLY ANNOYING. How do I stop the
shifting of the cells. I've tried to get around by using a case statement in
the SQL but instead of retuning zeros I get nothing back and the cells shift.
I tried to use SQL.REQUEST but can't seem to get the function installed.

2. How do I set up queries in Excel that don't constantly ask me for the
password to the database?

Thanks

Joe B

  #2   Report Post  
Arvi Laanemets
 
Posts: n/a
Default

Select any cell in returned query table. From Data menu, select
GetExternalData.DataRangeProperties - there you can set various properties.
Check 'Overwrite existing cells ...'.


--
Arvi Laanemets
(When sending e-mail, use address arvil<Attarkon.ee)


"DrLostinExcel" wrote in message
...
1. I am trying to create a Powerpoint Presentation from an Excel sheet

which
is linked to a MS-SQL database. When the queries return no data Excel will
shift the cells where the data should go up on the sheet throwing off the
links to the charts. This is UNBELIEVEABLY ANNOYING. How do I stop the
shifting of the cells. I've tried to get around by using a case statement

in
the SQL but instead of retuning zeros I get nothing back and the cells

shift.
I tried to use SQL.REQUEST but can't seem to get the function installed.

2. How do I set up queries in Excel that don't constantly ask me for the
password to the database?

Thanks

Joe B



  #3   Report Post  
DrLostinExcel
 
Posts: n/a
Default

Arvi,

Thanks, that did it!!

Joe B

"Arvi Laanemets" wrote:

Select any cell in returned query table. From Data menu, select
GetExternalData.DataRangeProperties - there you can set various properties.
Check 'Overwrite existing cells ...'.


--
Arvi Laanemets
(When sending e-mail, use address arvil<Attarkon.ee)


"DrLostinExcel" wrote in message
...
1. I am trying to create a Powerpoint Presentation from an Excel sheet

which
is linked to a MS-SQL database. When the queries return no data Excel will
shift the cells where the data should go up on the sheet throwing off the
links to the charts. This is UNBELIEVEABLY ANNOYING. How do I stop the
shifting of the cells. I've tried to get around by using a case statement

in
the SQL but instead of retuning zeros I get nothing back and the cells

shift.
I tried to use SQL.REQUEST but can't seem to get the function installed.

2. How do I set up queries in Excel that don't constantly ask me for the
password to the database?

Thanks

Joe B




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Fetching External Data from Excel Sri Excel Discussion (Misc queries) 2 January 3rd 05 12:46 PM
To safety merge cells without data destroyed, and smart unmerge! Kevin Excel Discussion (Misc queries) 0 December 30th 04 08:17 AM
Convert data of cells to any type: Number, Date&Time, Text Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:55 AM
How can I stop Excel from correcting data in a sp.sheetfor instan. AaronMahl Excel Discussion (Misc queries) 1 December 28th 04 07:30 PM
How to use a Access Query that as a parameter into Excel database query Karen Middleton Excel Discussion (Misc queries) 1 December 13th 04 08:54 PM


All times are GMT +1. The time now is 05:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"