+ Reply to Thread
Results 1 to 6 of 6

Unable to configure Excel 2019 the way I used Excel 2010.

  1. #1
    Registered User
    Join Date
    10-08-2020
    Location
    United Kingdom
    MS-Off Ver
    18.2008.12711.0
    Posts
    3

    Unable to configure Excel 2019 the way I used Excel 2010.

    For several years now I have used Excel 2010 as part of the home & student version of MS Office. A week or so ago I finally gave in to the prompting that support for 2010 would soon expire, and bought the current version. But I'm struggling to make it work as seamlessly as my old version did:
    • 1. First, I don't seem to be able to create separate shortcuts on my desktop for each of the MS Office components -- particularly Excel and Word which I use most.
      2. When I open MS Office from the symbol that's on my taskbar, and then click on the Excel symbol, it doesn't open a spreadsheet but simply gives me a list of recently used files (only one at the moment), with no way I can see of opening other Excel files. Only when I select one of the files in the recent list do I then see the normal spreadsheet presentation with the 'File' menu option at the top so I can open other Excel files stored on my PC.
      3. When I'm using a file I can see no way to close it without shutting down Excel, which means I have to re-start Excel to then use another file.

    Any ideas please on how to make my new Excel, and the rest of Office, behave like my 2010 version?

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Unable to configure Excel 2019 the way I used Excel 2010.

    Ya change sucks.

    When you first open excel, select the "open" Icon on the left side and then click "browse", you will then see the traditional Explorer window.

    If you want to close the activeworkbook, but not shut down excel goto file=>close this will close the active workbook.

  3. #3
    Registered User
    Join Date
    10-08-2020
    Location
    United Kingdom
    MS-Off Ver
    18.2008.12711.0
    Posts
    3

    Re: Unable to configure Excel 2019 the way I used Excel 2010.

    Thanks davesexcel. I open Office by clicking on the icon on my taskbar. Then I click on Excel in the list of icons down the left side of the Office screen, then I don't see any 'open' icon, but there is a left-pointing arrow right at the top left, and I've just found that by clicking on that I get a list of my files. So that's an improvement, thanks.

    But I agree that overall this change sucks. It takes me more steps to open and close my files, and I don't seem to be able to 'pin' them unless I save them on the cloud, which I don't want to do.

    Edit: Maybe I'm still doing something wrong, for even though I selected the Excel icon, when I click on the left-arrow I've just realised that it lists all my Office files, not just Excel.
    Last edited by stlucia; 10-08-2020 at 03:21 PM.

  4. #4
    Registered User
    Join Date
    10-08-2020
    Location
    United Kingdom
    MS-Off Ver
    18.2008.12711.0
    Posts
    3

    Re: Unable to configure Excel 2019 the way I used Excel 2010.

    I've just found I can 'pin' Excel' and 'Word' separately to my taskbar, and activating them from there gives me completel lists of their files when they start. Don't know why I was unable to find them as individual programs in my 'Start' listing previously.

    I'd rather have them as shortcut on my desktop, but I can live with them this way.
    Last edited by stlucia; 10-10-2020 at 06:39 AM.

  5. #5
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: Unable to configure Excel 2019 the way I used Excel 2010.

    To close a file whilst leaving Excel open, try using Ctrl-F4. I don't have the latest version of Excel, but I'd be surprised if that keyboard shortcut had been discontinued.
    Regards,
    Aardigspook

    I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.

  6. #6
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Unable to configure Excel 2019 the way I used Excel 2010.

    Re 3, closing the file.

    I'm assuming Excel 2019 looks like Office 365 Excel, in which case the top right hand 'x' although it appears it might close Excel does in fact just close the particular workbook.

    Yes, sometimes change is annoying. I'm still struggling to understand what #SPILL is doing and why.
    Also why entering say =A1:C1 in say E1 generates formulae in F1 & G1, and deleting those two isn't allowed.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro filter date works in Excel 2010 and not in 2019
    By Berna11 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-28-2020, 07:11 PM
  2. Unable to access hyperlinks in Excel 2010
    By chzuck in forum Excel General
    Replies: 0
    Last Post: 07-01-2020, 09:34 AM
  3. [SOLVED] Excel 2019 workbook with slicer won't work in Excel 2010 - help please
    By Excel enthusiast in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-07-2019, 12:59 PM
  4. Replies: 0
    Last Post: 09-27-2019, 03:34 PM
  5. macro works in excel 2019 but not in 2010 this gives type mismatch error 13
    By Newbikonob1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-20-2019, 06:25 AM
  6. VBA switches sheets running in excel 2019 v 2010+2007+2011 for MAC, where it does not
    By Ramses505 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-28-2019, 11:44 AM
  7. Unable to "Open" an exported excel (97-2003) during run time in Macros (Excel - 2010)
    By vmanoharan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-19-2018, 05:53 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1