#name error in excel ifs 671624-How do i fix the #name error in excel mulya marwan

The excel spreadsheets created have special functions for reading the data from the pivot tables contained in the report These are addins to...

選択した画像 excel use sheet name in formula from cell 101676 mulya marwan

 If all of the worksheets are in the same workbook, try using the INDIRECT function (refer to inbuilt help for syntax) Rgds, ScottO "ko...