Feedback by UserVoice

 

How can we improve Excel for Windows (Desktop Application)?

← Excel for Windows (Desktop Application)

Harmonize Excel.CurrentWorkbook with Excel.Workbook

Please adjust the M-function "Excel.CurrentWorkbook" so that it returns the same items (in the same structure) than Excel.Workbook (in connection with File.Contents) does:

Returning a table view of all elements with helpful columns like "Kind".

But most importantly also returning content from sheets that isn't in a special format like Table or Defined Name but in a simple range.

There are multiple reasons for letting the source-data untouched but also performing transactions on them and I've come across this request very often. The workarounds are pretty painful (error-prone and need to save file before being able to access data).

Thanks a lot!

68 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Imke Feldmann shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
declined  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded  · 

Thank you for posting and voting for this. Unfortunately, changing the implementation of Excel.CurrentWorkbook will break the existing solutions. With this in mind, we are currently not planning to do it.

Guy Hunkin
Principal PM
Excel Team

8 comments

Comments are closed An error occurred while saving the comment

Excel for Windows (Desktop Application): Data Import

Categories

Feedback and Knowledge Base

(thinking…)