Microsoft Data Insights Summit
June 12-13, 2017 | Seattle, WA
Discover new insights with the tools you use every day
Register now
9,221 Members

Excel Spaces

Discussions
Blogs
  • I have a spreadsheet with 3 tabs, "Scorecard" used to pull in data from the other two tabs "Raw Data Tod" and "Raw Data Jim".

     

    I have two formuals as per below that work independently of each other, however I want to combine the two formulas into one, so i

    ... Read More
    11 Views
    2 Replies
    , 03-22-2017

    Dear Steven,

     

    Try this:

     

    =IF(P13="Tod",YOUR FIRST FORMULA,
    IF(P13="Jim",YOUR SECOND FORMULA,
    ""))
  •  in Excel
    , 03-21-2017

    Since i upgraded to Office 2016 i have trouble opening Excel files from My Documents. 

    If i get an email with an Excel file - it will not open. 

    i can go into old emails and open workbooks from there but not the direct way.

    Excel opens but the workbooks are

    ... Read More
    15 Views
    1 Reply
    , 03-22-2017
    Yes I am having the same problem. All my excel worksheet are office 2007 and my 2016 365 will not open them. I need to go search for them each time. takes time to find
  • I have a spreadsheet with 3 tabs, "Scorecard" used to pull in data from the other two tabs "Raw Data Tod" and "Raw Data Jim".

     

    I have two formuals as per below that work independently of each other, however I want to combine the two formulas into one, so i

    ... Read More
    3 Views
    0 Reply
  •  in Excel
    , 03-22-2017

    I have two worksheets. Both have a list of customers. Worksheet 1 has 47 records, worksheet 2 has 400 records.

     

    The 47 records of worksheet 1 are in worksheet 2. But worksheet 2 doesn't have the email addresses, but worksheet 1 does. 

     

    What formula do I use

    ... Read More
    27 Views
    3 Replies
    , 03-22-2017

    Thank you, Wyn. I edited my post.

     

  •  in Excel
    , 03-22-2017

    When many files opened, I have to click   and wait for each  file being completed. This takes  a lot of time. Can it be  clicked only once and all opened files can be saved?

    12 Views
    1 Reply
    , 03-22-2017
    Hi

    There's no direct way, other than right clicking on your Excel icon on your taskbar, choosing close all windows and then click save each time.

    If you know a little about macros then you can save the following macro in your Personal Macro workbook and assign the macro to a button on your quick access toolbar:
    The macro below will save all the open Excel files that are not new. If you have a new file (for example, Book1) open that hasn’t been saved, it will not be saved by this macro.



    Sub SaveAll()

    Dim wb As Workbook
    Dim wbActWb As Workbook
    Application.ScreenUpdating = False
    Set wbActWb = ActiveWorkbook

    If MsgBox("Are you sure you wish to save all?", vbYesNo, "Close and Save All?") = vbNo Then

    Exit Sub

    End If


    For Each wb In Workbooks

    If wb.Path <> "" Then wb.Save

    Next wb

    wbActWb.Activate

    Application.ScreenUpdating = True

    End Sub
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.