4,150
hi folks
In management reporter if a level in my reporting tree has no data that level of the tree is not available in the MR viewer to drill do / or is visible.
When you export that report to excel however you get blank sheets for that level of the tree that has no data.
Is there a way to not export those blank sheets to Excel?
*This post is locked for comments
the internet geeks of the world at
windowssecrets.com/.../159777-moving-blank-tabs
wrote me a macro that will move the blank sheets to the end of the workbook.
sharing for other MR users (or the other 20 people that voted yes to the product enhancement
Option Explicit
Sub MoveBlankSheets()
Dim iShtCount As Integer
Dim i As Integer
iShtCount = Worksheets.Count
For i = iShtCount To 1 Step -1
If Application.WorksheetFunction. _
CountA(Worksheets(i).Rows("4:" & Worksheets(i).Rows.Count)) = 0 Then
Worksheets(i).Move after:=Worksheets(iShtCount)
End If
Next
End Sub
I took the vote to 21. looks like an older request.
And also one that looks like it may not be an enhancement given the comment posted against the suggestion:
Posted by Microsoft on 9/21/2012 at 10:32 AM
Correction from previous response. This is actually a support issue and not a feature request. Please work with Microsoft support to report this issue.
Best regards.
This posting is provided "AS IS" with no warranties, and confers no rights.
Hi Ian,
There is a suggestion for this. You can view the suggestion and vote on it here:
connect.microsoft.com/.../suppress-no-data-tabs-when-exporting-to-excel
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (