What is New in Excel for August 2022


Welcome to the August 2022 update. This month, we have many new features rolling out to Insiders and many more becoming generally available (GA) across web, Windows, and Mac. New functions to manipulate text and arrays including TEXTBEFORE / TEXTAFTER, VSTACK / HSTACK, CHOOSEROWS / CHOOSECOLS, and more are now GA; and the IMAGE function to insert images in cells is rolling out to the Beta channel for Insiders.

Excel for the web
  • New Excel Functions
  • Power Query Group operations
  • Improvements to the connected Power BI experience
  • Add and edit rich text formatting
  • Sort by color or icon from auto filter menu
  • Edit files with legacy data connections
  • Edit files with legacy Shared Workbook feature
  • Delete chart elements
  • Multiline formula bar
Excel for Windows
  • New Excel Functions
  • IMAGE function (Insiders Beta)
  • Improvements to the connected Power BI experience (Insiders Beta)
  • Show Changes (Insiders CC Preview)
Excel for Mac
  • New Excel Functions
  • IMAGE function (Insiders Beta)
  • Show Changes (Insiders CC Preview)
Android
  • New Excel Functions
  • IMAGE function (Insiders Beta)
iOS
  • New Excel Functions
  • IMAGE function (Insiders Beta)

Excel for the web​

New Excel Functions

14 new functions to manipulate text and arrays including TEXTBEFORE / TEXTAFTER, VSTACK / HSTACK, CHOOSEROWS / CHOOSECOLS, and more are now rolling out to users. Read more >

thumbnail image 1 captioned Text manipulation

Text manipulation

Power Query Group operations

You can now perform various operations on Power Query groups to better organize your queries and easily consume the data on the queries pane. Read more >

thumbnail image 2 captioned Power Query group operations

Power Query group operations

Improvements to the connected Power BI experience

In both Excel for the web and Excel for Windows, you can create a PivotTable that connects directly to a Power BI dataset. This allows you to analyze data between platforms seamlessly. With this set of updates, we improve the experience of analyzing data in PivotTables. Read more >

thumbnail image 3 captioned Power BI connected PivotTable

Power BI connected PivotTable

Add and edit rich text formatting

Rich text formatting allows the user to add formatting to only part of the text within a cell. You can use the ribbon or shortcuts to add the formatting.

thumbnail image 4 captioned Edit rich text

Edit rich text

Sort by color or icon from auto filter menu

Sorting is now easier and more convenient with new sort-by-color or icon options.

thumbnail image 5 captioned Sort by color or icon from auto filter menu

Sort by color or icon from auto filter menu

Edit files with legacy data connections

You can now edit files that contain legacy data connections like Text Queries, Web Queries, Query Table, or SharePoint Lists. This enables interaction with the workbook and access to the previously stored data from these connections, but without interaction, modification, or refreshing of the connections themselves. We recommend switching to import data via Power Query to connect and refresh data.

thumbnail image 6 captioned Edit files with legacy data connections

Edit files with legacy data connections

Edit files with legacy Shared Workbook feature

You can now edit files that use the legacy shared workbook feature, with a provision for one-click turn-off of the legacy feature, thus allowing you to interact and collaborate with the workbook.

thumbnail image 7 captioned Edit files with legacy Shared Workbooks

Edit files with legacy Shared Workbooks

Delete chart elements

Deleting a data series from charts is now easier by selecting a series and pressing the delete/backspace key to remove it.

thumbnail image 8 captioned Delete chart elements

Delete chart elements

Multiline formula bar

Users can now expand and collapse the formula bar by using the chevron or manually resizing it. This capability Improves the readability of long formulas or text

thumbnail image 9 captioned Multiline formula bar

Multiline formula bar

Excel for Windows​

New Excel Functions

14 new functions to manipulate text and arrays including TEXTBEFORE / TEXTAFTER, VSTACK / HSTACK, CHOOSEROWS / CHOOSECOLS, and more are rolling out to users in the Current Channel. Read more >

IMAGE Function (Insiders Beta)

The image function inserts images into cells from a source location, along with the alternative text. Your images can now be part of the worksheet, instead of floating on top. You can move and resize cells, sort and filter, and work with images within an Excel table. Read more >

thumbnail image 10 captioned Insert Image Function

Insert Image Function

Improvements to the connected Power BI experience (Insiders Beta)

In both Excel for the web and Excel for Windows, you can create a PivotTable that connects directly to a Power BI dataset. This allows you to analyze data between platforms seamlessly. With this set of updates, we improve the experience of analyzing data in PivotTables. Read more >

Show Changes (Insiders CC Preview)

Show Changes in Excel lets you see exactly what edits were made to your workbooks, so you can confidently allow others to collaborate on your work. You can see details of who changed what, where, and when, along with the previous value of the cell for quick reversion. Now available in the CC Preview Channel for Insiders. Read more >

thumbnail image 11 captioned Show Changes

Show Changes

Excel for Mac​

New Excel Functions

14 new functions to manipulate text and arrays including TEXTBEFORE / TEXTAFTER, VSTACK / HSTACK, CHOOSEROWS / CHOOSECOLS, and more are now rolling out to users. Read more >

IMAGE Function (Insiders Beta)

The image function inserts images into cells from a source location, along with the alternative text. Your images can now be part of the worksheet, instead of floating on top. You can move and resize cells, sort and filter, and work with images within an Excel table. Read more >

Show Changes (Insiders CC Preview)

Show Changes in Excel lets you see exactly what edits were made to your workbooks, so you can confidently allow others to collaborate on your work. You can see details of who changed what, where, and when, along with the previous value of the cell for quick reversion. Now available in the CC Preview Channel for Insiders. Read more >

Your feedback helps shape the future of Excel. Please let us know how you like a particular feature and what we can improve upon—send us a smile or frown.  You can also submit new ideas or vote for other ideas via Microsoft Feedback.
Click to expand...

Source:
techcommunity.microsoft.com

What's New in Excel (August 2022)

Welcome to the August 2022 update. This month, we have many new features rolling out to Insiders and many more becoming generally available (GA) across web, Windows, and Mac. New functions to manipulate text and arrays including TEXTBEFORE / TEXTAFTER, VSTACK / HSTACK, CHOOSEROWS / CHOOSECOLS...
techcommunity.microsoft.com
 
Click to expand...
Hi there
Image function is definitely fine -- I've been storing images into a MySQL DB (MariaDB) for a while via links but being able to store the actual image in place in to an EXCEL spread sheet cell is a brilliant one.

So I can run a query in excel from the MariaDB with "pictures from xxxx about yyyy" and I'll get a nice spreadsheet with the images in -- since I can also store the EXIF stuff this is a brilliant combination -- who needs any "Photo management" type apps with a combination of these two.

BTW for EXCEL to retrieve data via query from MariaDB / MySQL you need to install the ODBC driver for windows -- Free from the MariaDB site.

I'm messing around with things like

CREATE TABLE 'test'.'pic' (
'idpic' INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
'caption' VARCHAR(45) NOT NULL,
'img' LONGBLOB NOT NULL,
PRIMARY KEY ('idpic')
);

but it's probably better to hold the pics as a link on disk and store as follows by changing the relevant table:

ALTER TABLE `photos`
ADD COLUMN `image_path` varchar(1024);


Does Excel actually store the image in the cell with the image function or does it provide a link to the image on disk.

Anyway a few nice things to play with.

One possible snag though is you have to have OFFICE/365 to get the insider builds, but I'm sure feature will be rolled out to LTSC versions soon enough.

In current EXCEL it can be done if you enable macros but it's a bit tedious as per :

Option Explicit
Dim rng As Range
Dim cell As Range
Dim Filename As String

Sub URLPictureInsert()
Dim theShape As Shape
Dim xRg As Range
Dim xCol As Long
On Error Resume Next
Application.ScreenUpdating = False
' Set to the range of cells you want to change to pictures
Set rng = ActiveSheet.Range("A2:A600")
For Each cell In rng
Filename = cell
' Use Shapes instead so that we can force it to save with the document
Set theShape = ActiveSheet.Shapes.AddPicture( _
Filename:=Filename, linktofile:=msoFalse, _
savewithdocument:=msoCTrue, _
Left:=cell.Left, Top:=cell.Top, Width:=60, Height:=60)
If theShape Is Nothing Then GoTo isnill
With theShape
.LockAspectRatio = msoTrue
' Shape position and sizes stuck to cell shape
.Top = cell.Top + 1
.Left = cell.Left + 1
.Height = cell.Height - 2
.Width = cell.Width - 2
' Move with the cell (and size, though that is likely buggy)
.Placement = xlMoveAndSize
End With
' Get rid of the
cell.ClearContents
isnill:
Set theShape = Nothing
Range("A2").Select

Next
Application.ScreenUpdating = True

Debug.Print "Done " & Now

End Sub



Cheers
jimbo
 
Last edited:

My Computer

System One

  • OS
    Windows XP,7,10,11 Linux Arch Linux
    Computer type
    PC/Desktop
    CPU
    2 X Intel i7
Why don't they implement this simplified ribbon in the Desktop version???!!! praying.gif
 

My Computer

System One

  • OS
    Win 11 Enterprise
    Computer type
    Laptop
    CPU
    i7
    Hard Drives
    SSD
You must log in or register to reply here.

Similar threads

  • Article Article
What is New in Excel for August 2024
Replies
0
Views
298
Brink
Brink
  • Article Article
What is New in Excel for November 2024
Replies
0
Views
147
Brink
Brink
  • Article Article
What is New in Excel for October 2024
Replies
0
Views
252
Brink
Brink
  • Article Article
What is New in Excel for September 2024
Replies
0
Views
369
Brink
Brink
  • Article Article
What is New in Excel for July 2024
Replies
0
Views
381
Brink
Brink

Latest Support Threads

Latest Tutorials

Back
Top Bottom