If the above steps still do not resolve the issue then it is recommended to recreate a new trial balance report in order for the report to receive a new format that would prevent this or other issues in the future.

FreezePanes True End With dont forget Access has no clue what ActiveWindow is so you need to add the Excel object to it so it know where and what to do with it. Arrange the new Textboxes and align with the data columns as shown below. Select Freeze the 1st row With oExcel.ActiveWindow.

Click View > Ribbon Panes > Unfreeze Panes Step 4: Freeze Tablix Column Headers To freeze the headers, first add a Report Header in your report and copy each Textbox from the Tablix Row header to Report Header as shown below.

Do not press ALT + W + F + R in a hurry hold on for a moment.

Select all cells in the Microsoft Excel workbook. Step 2: Remember we are not only freezing the top row, but we are freezing multiple rows at a time.

Check out and open the Trial Balance Report.

If issue still has not resolved, unfreeze all panes and refresh the Trial Balance Report Properties:.

Click OK and allow to auto-refresh or manually click the Refresh button in the Engagement or Workpaper Manager ribbon.

You can also change other view settings, such as hiding the gridlines, to make the.

Click on the Engagement or Workpaper Manager ribbon. In an Excel file, you can lock the top rows in place, by using the Freeze Panes command on the Ribbons View tab.Check out and open the Trial Balance report.Refresh the Trial Balance Report Properties: 825-826 date function errors, 221 formulas errors in, 187-188, 195 performance issues, 435 freeze pane problems, 402 information function problems.The following options are available to workaround the issue with the freeze panes are: We are currently aware that for some trial balance reports created in CCH® ProSystem fx® Engagement and Workpaper Manager v7.5, the header's freeze panes are not being set correctly. The steps for freezing the first column of Excel are listed as follows: Step 1: From the window group of the View tab, click the freeze panes drop-down.

Excel freeze panes problems