Excel
The Excel community where you learn more about how to do something with Excel, discuss your work, and connect with the experts that build and use Excel.
8,657 Members

Excel Spaces

Discussions
Blogs
  • , 02-20-2017

    When using VLOOKUP, how can I get it to return a completely empty cell (with no spaces) when there is no result vs the zero length text cell that ("") produces when used?

    10 Views
    1 Reply
    , 02-20-2017

    Hello Cliff

     

    You want something like this:

    Give us a proper NULL() worksheet function.

    NULL Worksheet Function

     

    Go there, sign in and vote for this issue.

     

  • , 02-09-2017

    Hi friends,

     

    We have recently announced the January 2017 updates for Get & Transform in Excel 2016 and the Power Query add-in.

     

    In this update, we have released the following features:

    • New OLE DB connector.
    • Enhanced “Combine Binaries” experience when importing from any folder.
    • Maximize/Restore buttons in the Navigator and Query Dependencies dialogs.
    • Support for percentage data type.
    • Improved “Function Authoring” experience.
    • Improved performance for OData connector.

    Please refer to this blog post for more details:
    https://blogs.office.com/2017/02/08/january-2017-updates-for-get-transform-in-excel-2016-and-the-power-query-add-in/

     

    Guy

    - Excel Team

    49 Views
    1 Reply
    , 02-20-2017

    They say :

     

    "These updates are available as part of an Office 365 subscription. If you are an Office 365 subscriber, find out how to get these latest updates. If you have Excel 2010 or Excel 2013, you can also take advantage of these updates by downloading the latest Power Query for Excel add-in."

     

    What if I have Excel 2016 not being part of Office 365 ?

     

    Thanks

     

  •  in Excel
    , 02-14-2017

    Hello,

     

    I'm in need for your help. At the moment, I'm trying to make a file with the whole years planning. So far so good, but I've stumbled upon a problem. I hope you can help me.

     

    What I need is:

     

    A manner (probably VBA) that allows me to automatically change the background color of a cell, depending on the background color of another cell.

     

    For example:

     

    Imagine a file with 2 tabs in it:

     

    1. The "basic" tab

    2. The "week"tab

     

    Now, the two tabs are identical. If I where to change the text in cell A1 of the basic-tab, it changes the text in cell A1 of the week-tab. But, what I also need for it to do, is change the background color of said tab. If I change the backgroundcolor in cell A1 of the basic-tab, it needs to change the backgroundcolor in cell A1 of the week-tab.

     

    Thanks in advance!

    76 Views
    9 Replies
    , 02-20-2017

    Jonathan, that's where you need to think about your data architecture. You as the person in front of the monitor "know" that "this" value should be red and "that" value should be green, so you set the color manually.  If you take away the human intervention, then the colors don't have meaning that is based in the spreadsheet. 

     

    Can you post a small data sample of what you have in place right now, using dummy names and dummy numbers? Explain why things have different colors. Then we can try to work out how to make that work with data instead of only manually set colors. 

     

  • Hi all,

     

    Windows  10 fr, Excel 2016 fr.

     

    Any location is "not found", whether it's towns, countries, postal codes etc. Has anyone the same problem ?

     

    Thanks in advance.

    64 Views
    8 Replies
    , 02-20-2017

    Sorry... Nope, i have no idea how to remove. Try to press ones more or ask one of moderators to remove.

  • , 02-17-2017

    Hi,

     

    I am facing the below mentioned error, The VBA code run perfectly in my system, While using the same macro to another system it shows the below mentioned error:

     

    "The error commonly occurs when code is incompatible with the version, platform, or architecture of this application."

     

    I am really very frustrated with this error.

     

    Even Simple VBA code also prodcuced error e.g. I simple use Command button on the sheet and use Msgbox "Hi".

    Now the probelm is that This  works fine in my system. But when I send this workbook to someone else in my team then it shows the above mentioned error.

     

    I have tried following in the users system:-

     

    1. Delete *.EXD files in the user's temp folder

    2. re-install excel and  windows,  the same platform I have.

     

    I have developed N numbers of VBA automations but at some workstations my code procuded the above mentioned error and at some workstations it workes fine.

     

    Can anyone resolve this problem?  

     

    Regards,

    Arvind Kaushik

    55 Views
    5 Replies
    , 02-20-2017
    Thanks A lot, I never tried this option, I will try this and let you know if error still persist.
Excel Announcements
Announcements

This is the place to talk about Excel. You can learn more about how to do something with Excel, discuss your work, and connect with experts that build and use the product. With over half a billion Excel customers, we want to engage with you in fundamentally different ways and the community is a starting point for that. Our community helps answer your product questions with responses from other knowledgeable community members.