+ Reply to Thread
Results 1 to 2 of 2

Row Height Changes after Query Refresh

  1. #1
    Registered User
    Join Date
    12-21-2017
    Location
    Grand Rapids, Michigan
    MS-Off Ver
    2010
    Posts
    33

    Row Height Changes after Query Refresh

    So ... I have now determined I need to "get data" and place it directly into a new table for a reporting form I am creating. The number of rows changes as items are added and deleted. The data entry tab ( in a separate workbook ) contains no total bar at the bottom; the reporting tabs are where those should live. I know how to lock in the row height and column width of the query table itself after "getting data" and refreshing. However, my total row below the table does not dynamically adjust. The 1/2"-tall row either gets lost inside the table ( when rows are added ) or disappears far below the table ( when rows are deleted ). How do I get that total bar to move and lock with the table? Its data and fill color adjust just fine. So far, I have only noticed a issue with the row's height.

  2. #2
    Registered User
    Join Date
    12-21-2017
    Location
    Grand Rapids, Michigan
    MS-Off Ver
    2010
    Posts
    33

    Re: Row Height Changes after Query Refresh

    Bump, no response.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 01-24-2017, 11:22 AM
  2. Refresh all query & save. not enough time for query to complete.
    By mortphil in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-08-2015, 04:26 AM
  3. Replies: 2
    Last Post: 09-29-2013, 06:15 AM
  4. Replies: 1
    Last Post: 09-28-2013, 07:11 PM
  5. Problem with selecting range with in query table after query refresh
    By shooter in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-31-2012, 11:55 AM
  6. [SOLVED] Query parameter "refresh when value changes" doesn't refresh - why
    By Texas_Toast in forum Excel General
    Replies: 0
    Last Post: 01-04-2006, 11:35 AM
  7. Query Refresh-Enable Automatic Refresh Dialogue Box
    By Terri in forum Excel General
    Replies: 0
    Last Post: 05-06-2005, 04:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1