Page 1 of 2 12 LastLast
Results 1 to 10 of 17
Like Tree1Likes

Excel help file

This is a discussion on Excel help file within the Excel Questions forums, part of the Question Forums category; Good morning, I am sure I used to have Excel help on my system but if I select an item ...

  1. #1
    Board Regular
    Join Date
    Mar 2010
    Location
    Bradford, West Yorkshire, UK
    Posts
    1,804

    Default Excel help file

    Good morning,

    I am sure I used to have Excel help on my system but if I select an item in VBA and press F1 I always get sent online to help file, Is there something I should have installed?

  2. #2
    Board Regular MARK858's Avatar
    Join Date
    Nov 2010
    Location
    Southern England
    Posts
    7,583

    Default Re: Excel help file

    In the bottom right corner you will see Connected to Office.com. Click it and click Show content only from this computer.
    F1 should default to the last setting used.
    Test VBA on a copy of your data (remember you can't normally reverse the action)

    Please follow the forum Rules and Guidelines & please use Code tags around your code i.e. [CODE]your code[/CODE]

    To post a screenshot try one of these links
    MrExcel HTML Maker, Excel jeanie, RoryA addin (Win & Mac) or Borders-Copy-Paste

  3. #3
    Board Regular
    Join Date
    Mar 2010
    Location
    Bradford, West Yorkshire, UK
    Posts
    1,804

    Default Re: Excel help file

    Mark,

    Call me stupid (many do), bottom corner of what, I have looked on spreadsheet page and VBA page and see nothing,

    I am using 2007

  4. #4
    Board Regular
    Join Date
    Mar 2010
    Location
    Bradford, West Yorkshire, UK
    Posts
    1,804

    Default Re: Excel help file

    I have just clicked on the ? at the top of the excel spread sheet and its telling me help isn't working but I can get assistance from Microsoft online

  5. #5
    Banned user
    Join Date
    May 2014
    Location
    Germany
    Posts
    1,336

    Default Re: Excel help file

    Hi Dryver14,
    I had this problem a few times....

    _ This usually works:


    _ Get Into VB Development Window ( Alt F11 )
    _ Hit F1 (when in VB Development Window)
    _ You should see this

     photo HelpWindow_zpsqmn5qno2.jpg


    _ Click bottom left, and Select the appropriate option ( Not the online one )

    http://www.mrexcel.com/forum/excel-q...or-2010-a.html
    http://www.mrexcel.com/forum/excel-q...ml#post3847765
    Excel forums | Excel Matters ( scroll down to bottom of page )

    Alan
    P.s. ( I just tried this on XL2007, seems to work for me )

    p. P.s. ( I am in German Excel, but I think you should see something similar, but in English! )
    Last edited by DocAElstein; Nov 28th, 2015 at 05:03 AM.

  6. #6
    Board Regular MARK858's Avatar
    Join Date
    Nov 2010
    Location
    Southern England
    Posts
    7,583

    Default Re: Excel help file

    Quote Originally Posted by Dryver14 View Post
    bottom corner of what
    See the post DocAElstein made. It is the window that opens when you click F1 in the VBE.
    Test VBA on a copy of your data (remember you can't normally reverse the action)

    Please follow the forum Rules and Guidelines & please use Code tags around your code i.e. [CODE]your code[/CODE]

    To post a screenshot try one of these links
    MrExcel HTML Maker, Excel jeanie, RoryA addin (Win & Mac) or Borders-Copy-Paste

  7. #7
    Board Regular
    Join Date
    Mar 2010
    Location
    Bradford, West Yorkshire, UK
    Posts
    1,804

    Default Re: Excel help file

    Well,

    This is fun, I just upgraded only 100 quid (Vomit). no difference, I am now on excel 2016 but I don't get an option to go offline, it just opens up on line.
    Is it possible I always have to be online now to access things like object Library?

  8. #8
    Board Regular MARK858's Avatar
    Join Date
    Nov 2010
    Location
    Southern England
    Posts
    7,583

    Default Re: Excel help file

    Hmm, can't speak for 2016 (happy with my 2010) but the 2007 it should definitely work with. Not home to dig my old laptop with 2007 out but sure there wasn't any issue with it.

    The old pre 2007 help files were better and if you wanted them you had to do a download but I am sure I didn't do anything extra with 2007 and definitely didn't with my current 2010.

    Sorry I can't be of any more help.
    Last edited by MARK858; Nov 28th, 2015 at 09:03 AM.
    Test VBA on a copy of your data (remember you can't normally reverse the action)

    Please follow the forum Rules and Guidelines & please use Code tags around your code i.e. [CODE]your code[/CODE]

    To post a screenshot try one of these links
    MrExcel HTML Maker, Excel jeanie, RoryA addin (Win & Mac) or Borders-Copy-Paste

  9. #9
    Banned user
    Join Date
    May 2014
    Location
    Germany
    Posts
    1,336

    Default Re: Excel help file

    Quote Originally Posted by Dryver14 View Post
    Well,

    This is fun, I just upgraded only 100 quid (Vomit). no difference, I am now on excel 2016 but I don't get an option to go offline, ..
    Sorry i can't help more either. I just tried again in XL 2007 and on another computer with XL 2010... and all is well.

    Maybe if you can, "pull the plug" on yout internet connection and see if anything changes
    Alan

  10. #10
    Board Regular
    Join Date
    Mar 2010
    Location
    Bradford, West Yorkshire, UK
    Posts
    1,804

    Default Re: Excel help file

    No worries Mark, thanks for the research, I am sure the answer is there somewhere. I did prefer the layout of the offline help better than the online

Page 1 of 2 12 LastLast

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com