Feedback by UserVoice

Ed Hansberry

My feedback

  1. 3,408 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    759 comments  ·  Excel for Mac » PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Ed Hansberry commented  · 

    @anonymous - Keynote may be cool, but it is a PowerPoint competitor, not Excel. And I've used Numbers, and it is sorely lacking in what Excel can do, especially the new dynamic array functions. I tried Numbers for 3 months and couldn't get enough functionality out of it for my use cases. And it doesn't have a Power Pivot equivalent either, so not sure how that is better.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    Which office suite would you recommend @fred that we switch to that gives PowerPivot capabilities for macOS

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    That is for Power Query @massimo. I'm hoping Power Pivot will follow on later. Hoping...

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    @shahin - because Google Sheets or Numbers has a Power Pivot equivalent on the Mac? It has been a few years since I worked day to day in Google Sheets, but when I did, it's pivot tables didn't even compare to Office 2003.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    @anonymous - that is correct. The Mac doesn't have the necessary engine to refresh data in the Data Model that Power Pivot uses. Until MS adds Power Pivot to the Mac (if they do) you only have two options - install Excel for Windows on the mac via Paralells or similar software, or use Power BI. Power BI has the same engine as Power Query and Power Pivot, but returns the result to a web page, and any client with a web browser and permissions to the page can render it.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    @nathan - the price is for office 365 in general. You install whatever version you want for your computer OS.

    Since the price for the Windows version didn't increase with the addition of Power Query or Power Pivot, I'd surmise they consider that free enhancement.

    All that said, I want this on my Mac as well, but there is no pricing disparity.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    If you read this thread on Answers, it looks like MS is making some internal progress on this feature... at least the Mac recognizes there is a data model. https://answers.microsoft.com/en-us/msoffice/forum/msoffice_officeinsider-mso_mac-msoinsider_excel/workbook-using-a-new-feature-in-excel-for-windows/8f18af1c-d9df-40e1-8646-49a0d22ffb85

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    Google has Power Pivot?

    Ed Hansberry supported this idea  · 
  2. 1,829 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    Sounds like you aren't saving it as an *.XLSX file. If you save it back as a CSV, formatting is not saved, only data. I've never seen that happen (lose its format preferences) with a true Excel file.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    Barcodes should be treated as text as they can have leading 0s that any number format will remove. use Power Query to force text on the CSV import. Works every time.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    Thanks Urmi. I'll be very curious to see how this will be implemented without impacting previous models.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    @exacerbated. Yup, definitely happens. It is now second nature for me to press the windows menu key (usually to the right of the space bar), and the SV.

    That is Paste Special, Values.

    What is happening is the cell is formatted text, you are copying from somewhere else, even another app, and it brings a number format with it, then excel trashes it.

    If you paste as values, only the raw ASCII gets pasted in there, no formats, so the Text format in Excel persists.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    @Exacerbated - make sure the table column with the long digits is formatted in Excel as TEXT format. Editing/entering data will retain the text format and not convert to a number or lose precision.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    Power Query isn't a third party addon. And for importing text files, the learning curve is almost nil. It is far easier to use than the depreciated Text Import wizard, and far more accurate than just clicking on a CSV file and hoping it reads your mind.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    @corin - what you refer to is not the same thing. A part number with an "E" in it is not the same issue, but you are correct, Excel will try to convert to a number thinking it is scientific notation, unless you use Power Query (which you should) where you can tell it to leave that field as text. No one should be importing CSV files via plain old Excel if they want any level of control. Import via Power Query and get 100% control over every field.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    If you type in 123456789 into a narrow cell, it will change it to 1.2E+08 visually, but if you change the cell format to comma, currency, or whatever, it has retained 123456789 as the full precision.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    Ok. that is massive. M.******I.V.E. They could be working on that, but that would literally involve changing every single function that deals numbers (so all but the text functions), tables, pivot tables, Power Query, Power Pivot, Power Map, the Power BI enterprise app, Data Gateway, which all rely on the same 15 digit precision.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    It does that Zak. The issue only becomes an actual data problem when there are more than 15 digits. Excel cannot handle that so if you put in an 18 digit number, regardless of how it displays, it will change the last 3 digits to zero - unless you enter it as text.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    I see you've never talked to corporate lawyers before.

    And much like you have shot down my ideas on using Power Query which resolves about 95%-99% of the issues in this thread.

    Have a nice evening.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    You cannot put anyting on sheets taht isn't saved. It is automatically saved. You would have to close it, delete it, then empty the trash, and even then, not sure if there isn't a 2nd level trash can it is stored in for a while. Office 365 has that.

    And again, in a big corporation, permission for that involves lawyers, not your boss.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    Some of you don't understand how large corporations work. An employee can get fired for putting company data on ANY unapproved cloud solution.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    @Scott, Power Query does exist. The G&T name is for the Excel UI, Once in the query UI it is still referred to as Power Query, and is also used in Power BI.

    As to complexity, for handling CSV files, you don't need to know any M code. It is all push button in the UI.

    As for DAX, if you are using DAX in side of Excel via Power Pivot, you must learn Power Query. PQ is where you bring in your data, clean it, and create a structure for your data so it fits a clean Star schema, which is where DAX shines.

    I found out the hard way bringing in data directly via DAX was going to be a train wreck for all but the smallest data sets.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    @Corin, I think your mention of PowerShell is the first in this thread. I know PS is very powerful, but I have no idea how you'd use it with CSV files.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    Jody, solid workarounds (namely, Power Query) have been shown how to 100% avoid this issue EVERY SINGLE TIME, but some on this board would rather just rant.

    You are spot on RE: Google Sheets. Compared to Excel, that platform is a joke. It is like comparing a word processor to Notepad.exe.

    An error occurred while saving the comment
    Ed Hansberry commented  · 
    An error occurred while saving the comment
    Ed Hansberry commented  · 

    Corin and Todd, I only did the simplest of steps for a single file. I have power queries that look at a folder and always import the most recent two files which can be done based on file date OR contents of the file, such as an ASCII print header or text field, and then compares them. The file names are irrelevant in those cases.

    Export. Save. Refresh.

    That’s it.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    @corin - I never said people were relying on scientific notation. I said they were relying on the way it works today and have coded, made workflows, or formulas that handle it as is, then modify it as their needs dictate. If you change how the data comes in, that all breaks.

    My solution is not hacky - far from it. You should learn how to use Power Query. Try my steps and get a feel for it. This is what it is FANTASTIC at doing. You do the many steps ONE TIME. Your steps are recorded. Then you just refresh all and all those steps are applied again with a new CSV file. It is the total opposite of a hacky workaround.

    I never said MS ignoring it for decades was ok. I said the system has existed as it is for decades, and as such, people have modified their models accordingly. Furthermore, MS is NOT ignoring it. They addressed it above, and they addressed it in the Reddit AMA earlier this week. It is on the table for discussion, but I know a big sticking point is how not to break models that have been in existence for years, or decades, by changing behavior of what Excel does while still making it easier to work for people that don't know about Power Query, or that consider such an approach "hacky." LOL!

    Personally, with the advent of Power Query in Excel 2013, I would NEVER import a CSV file like you are doing. PQ gives me the ability to fix each field as I need, adjust the contents as I need, then dump to a table *EXACTLY* the way I want it, and then it does it day in and day out, months on end and I am never surprised at the results because I. DO. NOT. LET. EXCEL. MAKE. ANY. ASSUMPTIONS.

    PQ lets me control 100% of it. It works with leading zeros, text like 6E034, 50 digit numbers, etc.

    I personally don't care what MS does in this regard because I use the Power Query/Get & Transform model to control the data.

    What is hacky is double-clicking on a CSV file and then modifying it to suit your needs every time.

    Continue on though. I was just trying to give you a real world solution that works today hoping to save frustration until MS does whatever they will do whenever they may do it, which might be nothing and never. Or it could be a magical solution that pleases everyone and be released to the fast ring tomorrow. My solution is there today though, and I'd bet money if many people implemented it, they wouldn't even notice if MS ever did anything about the CSV import via the file menu or the old now depreciated Text Import Wizard.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    Daniel, not sure why the query method fails for you. This works 100% of the time for me:
    1) Data, Get Data (This is Excel 2016 - Excel 2013 is the Power Query addin)
    2) CSV file
    3) Edit button
    4) Change Data Type to Text - tell it to "Replace" if it converted to a number first, which it did with my credit card number test.
    5) Close and Load to a sheet (or data model if you need this in a Pivot table)

    Even preserved leading zeros.

    Save the Excel file.

    Get new CSV and drop it where the old one was with the same name.

    Open Excel File, Data Tab, then REFRESH ALL.

    Works every time.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    What was fixed in a later release?

    Also, I assume nothing. MS assumes they know how their product is being used by both regular users and fringe users, and they won't change something that breaks it for either.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    It isn't a simple thing to fix. Right or wrong, this is how it has worked for literally decades. Millions of spreadsheets are set up to work this way, and then adjust accordingly if the user wants the end result to be different.

    If MS "just changed it" millions of models would break overnight. So they have to move carefully to provide a better answer. Google doesn't have this problem. Their sheet is new and they did whatever they wanted to do, and honestly, if it changed something, some would complain, most wouldn't notice, and fewer would care. Excel is very different. Databases are built on it. Visual Basic code is built on it. .COM addins are.

    I know MS is working on this very issue. It was in their recent Reddit AMA on Wednesday of this week. But it is far from a "fairly simple issue to resolve."

    And the funny thing is, 99.9% of the issues in this thread are avoidable by using the Get & Transform feature in Excel 2013 and 2016 (also known as Power Query) or preformatting cells as text. So it isn't like you cannot use Excel to get the job done. You just have to do a few extra steps that actually GUARANTEE you the results you are looking for vs having the app make the decision for you.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    Zak, it isn't about using an inaccurate number. It is about using a number where you can trust the number of significant digits. Most numbers in science are rounded to some number of significant digits, unless you know exactly. For example the number of people on this thread fighting windmills is 1. Exactly 1. That is an exact and scientific number.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    I suspect this is the fix, which will be part of Office 2019 released in 2018. Just speculation though. Not a lot given in this announcement.

    https://techcrunch.com/2017/09/26/microsoft-excel-is-about-to-get-a-lot-smarter/

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    Seems to me a lot of this could be fixed if there were some addtional "autocorrect" options for Excel that we could disable.
    *Stop changing text to dates. If I type "Oct 2015" then I want "Oct 2015" in the cell, not 10/1/2015 formatted as MMM-YY
    *Stop changing math to dates. =9/12 is not my way of telling Excel to convert it to Sept 12 in DD-MMM format.
    *stop changing math to fractions. I cannot repro an example right now but too many times I've entered something like =8/6 because that is what I need in the cell but Excel will change it into a fraction, causing me to undo/redo until it stops.
    *The large numbers issue here (though that won't address people importing digits larger that 15 places as that is the max excel handles, all the rest becoming zero)

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    @zak - load two files (your favorite - CSV files) of something modest. Say 200,000 rows, 10 columns for one file, and 5,000 rows, 30 columns for another. Join them using two columns (like a customer number and state field), then report the summary by state and month. And for grins, the customer numbers all have 30 leading zeros.

    This is about 2-3 minutes work in Excel, including the preservation of the leading zeros. Let me know how Google Sheets works out for you.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    "The issue with Google Sheets is that..."

    And the fact that compared to Excel, Google Sheets is not even as powerful as Microsoft Works was. And I used Google Sheets at my prior company for 3 years.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    FWIW, I am not posting workarounds so MS doesn't have to fix it. I am posting workarounds so people can get their jobs done TODAY because whatever solution MS does evenutally come up with, it will change 20+ years of how Excel deals with some things, and in any event, I suspect MS will not even take changing how many digits Excel can handle (15) into consideration. As for the CSV stuff, yeah, it isn't ideal how MS handles it today.

    So, use the workarounds provided for now until whatever John [MS XL] posted about that is under review has something done about it, or wait.

    If I waited until everything was perfect to do my job I'd be fired on the spot. My whole job is workarounds. And I am thankful for them. Job security. :-)

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    @brent - PowerQuery is a great solution to this. But the expectation here is Excel to be a CSV file editor, which was never the intent.

    I use PowerQuery all of the time with CSV files to read data into Excel, but I use Access if I want to control exactly how CSV file output is done.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    " The big problem I have now is with account numbers that have a letter at the end, power query throws an error when trying to convert them to number format."

    It is because that isn't a number. Use the Number.FromText function inside a Try/Otherwise command.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    @zak - you should read up on the Excel calculation engine at http://www.decisionmodels.com/calcsecrets.htm. Being 16 bit, 32 bit, or 64 bit, has nothing to do with it. It has to do with how it was written and changing that would have massive MASSIVE issues to overcome. Not impossible, but not trivial.

    If Excel suddenly changed and said "ok, every thing I import that I cannot handle, I need to convert to text" that would break MILLIONS of models that have been written in companies since the 80's. I have had this issue in the past and I wrote models around the issue using import templates early on, VBA import routines, and now PowerQuery. If Excel changed now, it would break what I had others have currently written. Or if you expect it to be converted and understand the 15 significant digit limitation and know it isn't material to your model, then those models would be trashed if those values suddenly came in as text.

    That is the problem MS faces. They cannot just make a change to make it work for this without understanding how it will affect things that have been in existence for decades. It is like the 1900 date system in Excel where they screwed up and messed up the leap year when they programmed it. (or maybe it was Lotus that did that and Excel emulated it) If they just "fixed it" then people that had written functions to overcome the issue would suddenly find all of their calculations broken.

    Excel isn't like apps on your iPhone that can just be changed on a whim. This is not a simple issue for MS to fix. I do hope they come up with a resolution, because there is definitely a small army of people that seem to want to put credit card numbers in Excel and have it magically figure out what to do with it.

    Or, you could use PowerQuery in Excel and get around this. Or you could switch to Google Docs which doesn't have to worry about changing things like this, because no one with sophisticated models uses GDocs so no one would care if something changed.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    @zak, you are comparing apples and catalytic converters. Notepad isn't doing anything. It is simply showing you what is in the file. Excel has to process numbers, and the calculation engine is only capable of handling 15 digits. To change that would be an insanely massive undertaking. Every computer program in the world the processes numbers has a limit on the significant digits it can handle. Solar calculators is usually 8. Excel is 15. Engineering software may be 30 or more. Software used in physics and math may be 100. Whatever it is, when you exceed that limit, the software will start turning digits to 0 on the right to preserve the numbers on the left.

    If you want Excel to process it as text, then tell Excel it is text. Put it in quotes, or use PowerQuery to force it to text before loading it to a sheet or the data model.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    @zak - Power Query eliminates the hassle as you only write the query one time. You don't go through that horrible import dialog box.

    The problem is there is no standard for CSV files, but the rule of thumb is, numbers that should be treated as text should be enclosed with quotes. If you type 123456789123456789 into Excel, it will remove the last 5 digits because it simply cannot handle numbers with more than 15 significant digits.

    I am not defending how Excel does it. I personally hate the autoformat garbage it does all throughout the app. Type "1 1/2" and excel assumes I want a fraction. It changes it to 1.5, then formats as a fraction. I have to undo that and force the cell as text format, or preceed with a ' character (single quote)

    I am merely showing a way to avoid the issue. If you want more than 15 digits, you need to switch products. MS Access supports 28 significant digits for example if you make the field decimal.

    And I just formatted a cell as text, put in a 21 char "number" into that cell, and saved as a CSV. Opened in Notepad and there was no truncation. Excel correctly saved all 21 digits to the file. It didn't put quotes around it though, so when I opened it up, it did truncate. When I imported via Power Query though, it kept all digits.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    @Steve Burkhart, Excel's conversion to scientific notation isn't losing your data. Excel simply cannot handle more than 15 digits in a number. Period. If the file you are exporting is creating a CSV, you need to have it wrap the number in quotes. Excel will handle as text.

    Or use Power Query built into Excel (2016) to do the import. There you can force the import as text and then when you load it to an Excel spreadsheet, it will come out as text and all your digits will be intact.

    If you have 2013, you need to download the Power Query addin. I don't think it exists for 2010, and know it doesn't for 2007.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    http://dailydoseofexcel.com/archives/2017/04/05/converting-numbers-to-text/ has info on how to put credit card numbers in Excel. The issue is Excel isn't broken, it just isn't being used properly. CC numbers aren't numbers, they should be strings, and should be entered as such. Excel cannot even handle a 16 digit number, which many CC #'s are.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    Access can track it, but so can Excel. you just need to format the cell as TEXT before pasting the values in. That is what the TEXT format is for. Excel cannot handle a 22 digit number. Neither can Access for that matter. You'd need to format the table field as a TEXT/STRING field as well before adding the data in.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    Roger, Excel doesn't destry numbers. It just converts the format, You can change the format back. That said, Excel only supports 15 digits. Entering 1234567890123456 will result in 1234567890123450 being in the cell.

    For things like tracking numbers and IDs, those should be text anyway. In our company, anything that is any type of ID is always text, even zip codes, which are only 5 digits.

    Ed Hansberry supported this idea  · 
  3. 3,789 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    979 comments  ·  Excel for Mac » PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →

    We are pleased to announce that the first set of Power Query features are now available in version 16.29 and greater. At this stage you can refresh from text, CSV, XLSX, JSON and XML files.

    Refer to the following blog post for more details:
    https://techcommunity.microsoft.com/t5/Excel-Blog/Get-amp-Transform-Power-Query-in-Excel-for-Mac-Phase-1/ba-p/876840

    I encourage you to try the new functionality and share your feedback with us via Send a Smile/Frown at the top right corner in your Excel for Mac.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    Yes, XLSM would be supported as the spreadsheet is the same. I would be curious to know if it supports XLSB and XLS. Kinda doubt it as those are very different file formats, not XML based.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    Now available for Office Fast Insiders!!! https://blog-insider.office.com/2019/05/30/you-asked-for-it-a-journey-to-power-query-in-excel-for-mac-starts-now/ Only supports CSV, XLSX, and a few other files. Hopefully more support coming soon!

    An error occurred while saving the comment
    Ed Hansberry commented  · 
    An error occurred while saving the comment
    Ed Hansberry commented  · 

    I think it is Power Query and Power Pivot are built on .NET framework and AFAIK, the full .NET framework isn't available on macOS, so either they have to rewrite both in C# or C++, or the .NET framework that is available on macOS has to be beefed up.

    Even though Power Query is now native to Excel 2016 vai Get & Transform, it still launches .NET to get to the query builder. That is why both it and Power Pivot look so different from Excel. They are outside programs not part of the core Excel.exe file.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    @marcos - I would think the main reason is the Dot Net framework. Power Query and Power Pivot are both written in Dot Net on Windows. There is a Dot net core framework available for the Mac, but my understanding is the core is missing a ton of features of the full framework. So to get PQ and PP on the Mac, either the dot net framework has to be substantially improved on the mac, or PQ/PP have to be rewritten in in a language for the Mac, which means two different apps, and MS is moving away from that. They just got the Office codebase sync'd up this year!

    Ideally I'd like to see PQ and PP rewritten on Windows in C/C# to speed up the UI and performance, then used on the Mac as part of the common code base.

    This is speculation on my part. I am not a developer or MS employee. But I do know dot net on the mac is severely lacking compared to the same on Windows.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    Thanks. The parts are *very* different and didn't come to Excel for Windows at the same time, so wouldn't expect these to either. But... Power Query first!

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    @anna, that is what you should do. There is no "minimum threshold" to get a feature added. I've seen requests with 50 votes get added and there are some with over 3,000 votes that don't have a "working on it" or even a "under consideration" yet.

    There is a cost factor, and unfortunately I think this one is pretty high. But it is safe to say, the more votes it gets,the more likely it is to happen.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    Critical for Mac Office to be taken seriously for finance/accountants that automate a lot of data calculations with these tools.

    Ed Hansberry supported this idea  · 
  4. 1,260 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for all of the votes – the team has definitely taken notice of the activity around this issue. We moved to SDI as a result of customer requests, but it looks like we’ve got work to do to really nail the use cases people care about. From a read over the comments, I see a number of cases that we will want to investigate further as we think through MDI vs SDI. We’ll get someone from the team to take a deeper look, and we may reach out to some of you for more clarification as we go. Thanks again for all the voting and passion here!

    John, Excel

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    @adam please stop spamming unrelated ideas with this one. If everything crossposted their favorite idea in 10-15 other ideas the value of this site goes down. I wasn’t pleased to have 10+ emails from uservoice today from many ideas I am following to see the only update was you spamming all of them.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    You all do realize that there are not multiple instances of excel, right? Just one. Each workbook is its own window though so you can easily have on different monitors without having to force a 2nd instance of Excel. It is like Outlook - open 3 emails and they are in separate windows, but there are not 3 instances of outlook.exe running.

    Look at the detail listing in task manager. You'll see Excel.exe only one time.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    So you can open two excel files and have them in separate monitors.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    This feature was not removed. Unless there is something wrong with your configuration of Excel, or you *specifically* right-click on the Excel icon on the task bar and force another instance, all workbooks are running in one Excel.exe instance.

    What did change is each Excel uses an MDI (multiple document interface) model so each workbook now is its own window, which is essential for users with multiple monitors. I can have a workbook on each screen now. The

  5. 15 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    Seems odd this isn't possible You cannot even do it via VBA. The DisableMoveResizeUI property doesn't exist for Timelines. :-/

    Ed Hansberry supported this idea  · 
  6. 735 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Great suggestion – thanks again for taking the time to put it on this site and for the thoughtful followup comments. This is pretty related to some other work we’ve got going and already has a fair number of votes, so we’ll work on getting plans in place now and hope to get started on this soon.

    Thanks,
    John [MS XL]

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    PowerApps has a BLANK() function as well. It would seem to make sense to add this to Excel for consistency, and perhaps a NULL() in both, though in PowerApps, it treats null and blank as the same.

    Ed Hansberry supported this idea  · 
  7. 1,041 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks again for all the passion on this issue – we hear you and we’ll get someone on the team to dig in to the issue. I’ve seen a few related sub-issues while scanning over the comment section for this one, so we may reach out to a few of you for clarifications. Thanks again for all the votes, and keep them coming for the issues you care about!

    John, Excel

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    Roy - I understand if you have two instances of Excel open then they will have separate undo stacks. But the transition from MDI to SDI did not change the fundamental way Excel works. Open 5 workbooks in Office 365, Excel 2016, or Excel 2019, and you only have one copy of Excel.exe running, unless you specifically caused a 2nd instance to launch (Alt-Click Excel icon).

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    Roy, MDI and SDI don’t affect the number of instanced of Excel. Still one instance. SDI allows us to move files between monitors though.

    Ed Hansberry supported this idea  · 
  8. 706 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    Center Across Selection should be the default action as it has the least amount of side effects (destroying ability to sort, causing problems for Tables, adding data to Power Pivot or Power Query, etc.)

    Ed Hansberry supported this idea  · 
  9. 68 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    Excel has a button to clear all links in Data|Edit Links, but it only seems to work well on links in cells in the spreadsheet, not links in the Name manager, or hidden or more obscure links. That button should wipe out ALL links.

    Ed Hansberry supported this idea  · 
  10. 279 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    Honestly, I'd be ok if we just got the "Center across columns" button. ;-)

    Ed Hansberry supported this idea  · 
  11. 17 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ed Hansberry supported this idea  · 
  12. 7 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ed Hansberry shared this idea  · 
  13. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Excel for the web » Editing  ·  Flag idea as inappropriate…  ·  Admin →
    Ed Hansberry shared this idea  · 
  14. 34 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Excel for the web » Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
    Ed Hansberry supported this idea  · 
  15. 31 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ed Hansberry supported this idea  · 
  16. 478 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    160 comments  ·  Excel for the web » Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
    Accepting Votes  ·  Tamar Tzruya responded

    Thanks for your feedback! We’re reviewing your suggestion. I would like to clarify: If sharing through SP the URL parameters are hashed. When a user edit an Excel file and copy the URL for sharing over email the user can choose to change the action to edit.
    Remember, the more votes a suggestion gets, the more likely it is that we’ll do it.

    Tamar [MSFT]

    Ed Hansberry supported this idea  · 
  17. 583 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ed Hansberry supported this idea  · 
  18. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ed Hansberry shared this idea  · 
  19. 9 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ed Hansberry supported this idea  · 
  20. 5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Ed Hansberry commented  · 
    Ed Hansberry shared this idea  · 

Feedback and Knowledge Base