Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
! ! ! ! !Hi All
I have create my app using a lot of hide sheet.
vSheetVisible=1
only when sheet is activate it then appear. my issue is a lot of hide sheet in my app are useless, i like to delete them.
But it is hide , i am unable able to locate them. so i cannot delete them.
Now i like to ask it there a command to force all sheet activated ?
Enclsoed my QVW , which have
vSheetVisible=1
vSheetVisible=2
vSheetVisible=3
how to make all of them not hide ?
Paul
Press Ctrl + Shift + S to view all the sheets
Hi Paul,
In Settings> Document Properties> Security Tab
check "Show All Sheets and Objects" option then you will see all sheets in front end.
You can delete all unwanted sheets and Uncheck the option again in settings.
-Ashok
Press Ctrl + Shift + S to view all the sheets
Or view them under Document Properties
Hi Ashok
I have try to set , but it does not work . Where go wrong ?
Paul
Get Outlook for iOS<https://aka.ms/o0ukef>
Hi Ashok
I just check using my enclosed example , you approach work.
But in my actual QVW doc , it have more then 300 sheet . It does not work.
Remark :- My doc getting slow in loading, due to Yoo many sheet . I need to reduce those sheet which hide due to I have forget the number.
Paul
Get Outlook for iOS<https://aka.ms/o0ukef>
Hi Sunny
Control Shift S work fine now, my next issue is after that i am not able to open the sheet to view the chart and table . any work around ? As i need to view the page to see it the report it is impt ? if not i want to delete it. now i cannot view them.
Delete your unwanted sheets directly from the document properties window
Hi Sunny
I manage to do a cleaning of a lot of old sheet , now it is okay and can load very fast. As those old sheet I only use once in every yr , so no point keep them. A lot of report now I do in QS , so the clean up will help a lot in speed up.
Paul
Get Outlook for iOS<https://aka.ms/o0ukef>
That's awesome