I have a Workbook with a master Worksheet where ALL records are added/updated - I then have a series of departmental Worksheets that are Refreshed by a series of Power Query queries based on the value of the Department column in the master Worksheet - it all works fine apart from one of the departmental Worksheets which for some reason hides (or reduces the row height to a very low value) of the last row in the table after EVERY refresh - I have checked (and checked again!) that there is nothing different in the Power Query settings (or the Table/Properties) but cannot work out why!
Anyone got any ideas?
Many thanks ...
Anyone got any ideas?
Many thanks ...