View original (French)

Number of sheets in an Excel workbook?

Solved
SBOSBO -  
 GariDmaths2015 -
Hello,

I would like to know how to retrieve the number of sheets in an Excel workbook.

Thank you in advance

5 réponses

Réponse 1 / 5
Patrice33740 Posted messages 8400 Registration date   Status Membre Last intervention   1 781
 
Hello,

Formula:
=INFO("nbfich")

--
Nicolas always says: "It's easy when you know the answer!"
5
johannenzo Posted messages 35 Status Membre 1
 
Hello,

this formula works but it does not display the correct number of sheets in my workbook!!!
My workbook consists of 12 tabs, each containing 1 sheet, and the formula result shows 29 instead of 12!!!
Why?
Best regards
0
tontong Posted messages 2575 Registration date   Status Membre Last intervention   1 064
 
Hello,
For the explanations see post #6
For the solutions #5 or #7
0
Simon
 
Hello, it's working:

=INFORMATIONS("nbFeuil") => "nbfich" = Number of active worksheets in the open workbooks.

You must therefore open one workbook at a time.
0
GariDmaths2015
 
The formula:
=INFO("nbfich")
works correctly and calculates the total number of Excel sheets in all open Excel documents. (Note: "nbfich" and not "nbfeuil").
However, I am looking for a formula that gives the total number of A4 pages in the Excel file.
0