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 answers

  1.
    Patrice33740 Posted messages 8400 Registration date   Status Member Last intervention   1 784
     
    Hello,

    Formula:
    =INFO("nbfich")

    --
    Nicolas always says: "It's easy when you know the answer!"
    5
    1. johannenzo Posted messages 35 Status Member 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
    2. tontong Posted messages 2575 Registration date   Status Member Last intervention   1 064
       
      Hello,
      For the explanations see post #6
      For the solutions #5 or #7
      0
    3. 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
    4. 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