I have a defined function in an excel file. When i paste the funtion in any cell it returns a value. I tried finding out where/how is it fetching the value through formula auditing, where i saw it's pulling the value from a sheet named Data2, cell g23, though this sheet is not showing in the file.
I also tried to find it out from the Format >> Sheet >> Unhide option but it's not even there.
Then I also used ctrl+g (goto) to figure it but not succeeded. Had it been a sheet which does not compleatly exists in the file then Goto option must have prompted an error but it did not.
Can anyone help me figuring out the sheet where it is and how it has been hidden/protected in such a way that it's hard to find.
I also went through the protection options to check if the file is anyhow protected to keep things invisible but it's not.
Regards
Premanshu.
I also tried to find it out from the Format >> Sheet >> Unhide option but it's not even there.
Then I also used ctrl+g (goto) to figure it but not succeeded. Had it been a sheet which does not compleatly exists in the file then Goto option must have prompted an error but it did not.
Can anyone help me figuring out the sheet where it is and how it has been hidden/protected in such a way that it's hard to find.
I also went through the protection options to check if the file is anyhow protected to keep things invisible but it's not.
Regards
Premanshu.
>
