My question may be a bit simplistic,but can i drill through from one excel sheet to another?
I have researched quite a bit and some say it cannot be done??? I have doubts.
In layman terms,i want my 2nd level drill through report to open in the new excel sheet/tab. Can it be done? if yes,how?