logo
  • Excel Charts
  • About David Aldred & This Blog
  • Consulting & Excel Support

Category: Google Sheets

Warning: Opening Excel Files with Array Formulas in Google Sheets

September 23, 2016 2 comments Article Google Apps, Google Sheets, Intermediate

From time to time, you might have to work with both Excel and Google Sheets interchangeably. Generally, opening fairly standard Excel Files in Google Sheets works fine – Google has strong support for most Excel functions. More complex or large worksheets generally fail to open in Google Sheets – not ideal, but at least there’s no hiding from Read More

Most Read Articles

Using the IFS() and SWITCH() Functions to test for more than one condition in Excel 2016
Creating Virtual Tables in Power BI Using DAX
Showing Data Bars as a 'Proportion to Total' in Excel
Populating one Drop Down based on the Selection of Another in Excel – Without VBA
Format or Remove Borders from a Slicer or Timeline in Excel

Meta

  • Register
  • Log in
  • Entries RSS
  • Comments RSS
  • WordPress.org

Categories

Pages

  • Excel Charts
  • About David Aldred & This Blog
  • Consulting & Excel Support

Copyright System Secrets 2022 - Theme by ThemeinProgress