Welcome to SpreadsheetWEB Blog

 

Excel Named Ranges

Users of all levels have different feelings about Excel named ranges. Some find them cumbersome, while others use them religiously. In addition to allowing quick access to complex references, named ranges can make your formulas a lot easier to read and...

What’s New in SpreadsheetWeb 6.2

Since its addition in 6.0, the designer module has proven to be an excellent tool for creating professional looking web applications filled with features. We’ve been constantly updating the designer to give our users the best experience possible, while...

How to Password Protect Excel Files

Some Excel files are the result of months of development and you may not want to pass this work to everyone lightly. Be it for protecting your intellectual property, monetizing your data model, or simply preventing user errors, there are several reasons...

Improving VBA Macro Performance

Creating macros in Excel can be a difficult task, especially if you’re just starting out. However, Excel thankfully has several features that are designed to help developing macros. For example, calculations automatically update after every action, the...

Floating Point Calculation Issues in Excel

As one of the most versatile calculators ever created, Excel is utilized to power innumerable business operations daily; however, can it ever fail to give you the correct results? In the case of floating numbers, it can. The term floating point refers to...

Transforming Data Tables with Excel’s Text Formulas

One of the popular uses of Excel is in data analysis and reporting applications. However, row data often must be organized and restructured before using in reports or other calculations. For example, when capturing individual names, product IDs, or other...

Least useful Excel formulas

Microsoft Excel features more than 400 formulas that users enjoy when creating marvelous data models, calculators, and fun tools. Microsoft keeps adding new ones every now and then, but usually also keeps the existing ones for the sake of backwards...

Known Formula Issues in Excel

Why can’t I use dates before 1/1/1900? I am getting 2 different results for the same calculation, how is that even possible? You might be asking yourself these types of questions, but worry not, Excel can be quirky at times. It may not be your fault after...

What’s New in Version 6.1

We’ve introduced the designer module in 6.0 with the purpose of decoupling the user interface creation from Excel workbooks. This approach proved to be very successful with its intuitive interface and added features. In the 6.1 version, responsive...