SpreadsheetWEB
  • Home
  • Pricing
    • Cloud Pricing
    • Server Pricing
  • Applications
    • By Industry
      • Education
      • Insurance
      • Investment
      • Public Sector
      • Startups
    • By Department
      • Finance
      • Human Resources
      • IT
      • Sales
    • By Type
      • Data Collection
      • Data Visualization
      • Online Calculators
      • Online Reports
      • Mobile Applications
  • Services
  • Resources
    • Blog
    • Case Studies
    • Data Sheets
    • Demos
    • FAQ
    • Resources
    • Tutorials
    • User Guide
    • Video Tutorials
    • Whitepapers
  • About
    • About Us
    • Contact Us
    • Customers
    • Press Releases
  • Try for Free
Select Page
How to get the worksheet name, workbook name, and its path

How to get the worksheet name, workbook name, and its path

by Ilker | Apr 6, 2018 | Excel Tips & Tricks

Working across several workbooks with multiple sheets can be tedious. Furthermore, file names are dynamic and can be changed by your users. Use this simple trick to organize your data and label workbook details. Syntax =CELL(“filename”, reference which is...

Recent Posts

  • Utilizing Web Services in Excel Using Formulas
  • What’s New in SpreadsheetWeb 6.3
  • Pagos Announces the Release of SpreadsheetWEB 6.3 Featuring a New Dashboard Module and Improved Calculation Engine
  • Data Analysis in Excel: PivotTables versus COUNTIFS, SUMIFS, AVERAGEIFS formulas
  • HubSpot Setup – Integrate SpreadsheetWeb applications with HubSpot
  • What week of the year is it and how to get its end date
  • What week of the year is it and how to get its start date
  • How to find unique values Excel
  • How to highlight empty cells
  • 3D References in Excel
  • Facebook
  • Twitter
  • Linkedin

© 2018 Pagos, Inc. - All rights reserved - Privacy Policy - Terms of Use