Forum

Notifications
Clear all

ListSheets formula is not working at some excel sheet

3 Posts
2 Users
0 Reactions
160 Views
(@ayemu7)
Posts: 197
Reputable Member
Topic starter
 

Hi Team,

I will require to list the sheets by using {=@INDEX(ListSheets,1)}.

That is working in some files and but not all the time. Please see the one not working.

where do I have to check it too.

thank you.

Regards,

Aye

 
Posted : 11/08/2021 8:41 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Aye,

The formula is referring to a name ListSheets except there is no name set up in that file, which is why you're getting an error! See this tutorial on how to list sheet names.

Mynda

 
Posted : 12/08/2021 3:41 am
(@ayemu7)
Posts: 197
Reputable Member
Topic starter
 

Many thanks, Mynda.

The video is better than what I required.

Much appreciated.

Regards,

Aye

 
Posted : 13/08/2021 4:34 am
Share: