We have a batch job that programmatically generates an SSRS report in Excel format and then applies a VBA Excel macro which is contained in another Excel worksheet. This procedure had been working fine when used with Excel 2010. When we upgraded our servers where the batch job is run to Excel 2013, the behavior of the formatting changed.
Specifically, one of the issues is with the freezing of panes. In the VBA macro a cell is selected on a sheet and the “ActiveWindow.FreezePanes = True” is called to freeze the panes. This was working when navigating the finished worksheet when we had Excel 2010 installed but is not after upgrading to Excel 2013. Curiously, when the finished worksheet is opened in Excel and you select “View -> Freeze Panes” the “Unfreeze Panes” option is available - not the “Freeze Panes” option. It’s as if Excel knows the panes have been frozen in this worksheet but is not honoring it when navigating the worksheet.
Another twist to this is that the formatting does work correctly if the batch job is run under certain Windows user accounts.
Perplexed here. Any ideas??
Thanks!
John R.
Specifically, one of the issues is with the freezing of panes. In the VBA macro a cell is selected on a sheet and the “ActiveWindow.FreezePanes = True” is called to freeze the panes. This was working when navigating the finished worksheet when we had Excel 2010 installed but is not after upgrading to Excel 2013. Curiously, when the finished worksheet is opened in Excel and you select “View -> Freeze Panes” the “Unfreeze Panes” option is available - not the “Freeze Panes” option. It’s as if Excel knows the panes have been frozen in this worksheet but is not honoring it when navigating the worksheet.
Another twist to this is that the formatting does work correctly if the batch job is run under certain Windows user accounts.
Perplexed here. Any ideas??
Thanks!
John R.
