+ Reply to Thread
Results 1 to 6 of 6

Excel 2013 unusable for me; for mission-critical project, go back to 2010 or 2007? Help!

  1. #1
    Registered User
    Join Date
    09-19-2006
    Posts
    39

    Excel 2013 unusable for me; for mission-critical project, go back to 2010 or 2007? Help!

    Hi everyone, sorry, this is a bit long, but the point is in my headline, and main questions consist of the 2 options at the end of this. The rest is background.

    I'm on a 64 bit Windows 7 PC. I'm doing something mission critical -- a model which I started a few years ago in Excel 2007 on Win 7. For my purposes then, it was flawless, so far as I could tell, and it would cover me for what I'm doing now. I didn’t and don't need / use any of the new features in 2010 or 2013.

    I now need to amend the model, for a client who’s counting on me. There’s time-pressure too. I no longer have my PC with Excel 2007, so on another W7 PC I installed a copy of Excel 2010 which I'd bought but never used. I've since got a lot of new work done now in 2010. Basically 2010 has been fine with one exception which causes me a headache -- as has been noted on a number of forums, Excel 2010 doesn't copy conditional formats the way it should. (Seems stuck in absolute reference mode, even when you remove $ signs from references.)

    So I bought Excel 2013 and after just a few hours realize I cannot continue with it. This is not debatable. To be very brief, it freezes, crashes, won’t save (my PC has plenty of CPU and RAM) and makes viewing 3-4 arranged sheets at once basically impossible as the now each has its own menu and formula bar, so I can barely see any rows. This behaviour can’t be turned off. So, bye.

    So I have two options, and would like advice from Windows 7 people. Please bear in mind
    a) again, this is mission-critical
    and
    b) that the substantial work that I don't want to have to redo has been done only in 2007 and then 2010. (The few hours of bug-discovery in 2013, I can write-off. )

    Option 1) Remove 2013, install 2010 again. Live with the conditional formatting bug. But will my client and end-user (a 2013 user) be ok? Will anything cripple the underlying calculations? There's nothing fancier than a few lookup tables and basic logical functions; there is no complex VBA, or any pivot tables etc. It doesn’t use anything beyond what’s on 2007.

    Option 2) Remove 2013 and buy/install 2007 and use that. Not happy about paying MS yet again under the circumstances, but whatever, as I said, I need Excel now, and 2007 has always worked fine for me in all respects. My only worries: a) will the large chunk of work I've done in 2010 open and work ok in 2007? I am quite sure I have not, in 2010, used any 2010-specific feature, function etc. b) As before: will my client and end-user (a 2013 user) be ok?

    Much obliged for any advice…

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Excel 2013 unusable for me; for mission-critical project, go back to 2010 or 2007? Hel

    1 you need to uninstall MSO2007 and younger with special MS software
    2 i' ve used my MSO2013 32bit installer quite a few times. Everything is fine

  3. #3
    Registered User
    Join Date
    09-19-2006
    Posts
    39

    Re: Excel 2013 unusable for me; for mission-critical project, go back to 2010 or 2007? Hel

    Quote Originally Posted by tim201110 View Post
    1 you need to uninstall MSO2007 and younger with special MS software
    2 i' ve used my MSO2013 32bit installer quite a few times. Everything is fine
    Thank you Tim but it seems you have not read my post. MSO 2007 has never been on this machine, and I know I don't want MSO 2013 at all, so being able to install it several times doesn't help me. I'm asking which is the safer option under the circumstances, 2007 or 2010.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Excel 2013 unusable for me; for mission-critical project, go back to 2010 or 2007? Hel

    I find Excel 2010 (32-bit on W7) much improved over Excel 2007 and very stable. I have heard it said (and find it very believable) that 2010 is the version 2007 was supposed to have been. I don't know what CF bug you're referring to.

    That said, my younger daughter uses Excel 2013 for very large, very complex financial models without difficulty. And having said that, Excel 2013's SDI, which people whined for for years, seems to have its share of warts.

    I still maintain Excel 2003, but I dumped 2007 several years ago.
    Last edited by shg; 04-01-2016 at 02:06 PM.
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Excel 2013 unusable for me; for mission-critical project, go back to 2010 or 2007? Hel

    OK, let's try one more time
    i've used my MSO2010 (full) 32bit installer quite a few times. Everything is fine
    MSO2010 and 2013 are stable. Even my instalation files are relable
    something is wrong with your OS

  6. #6
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Excel 2013 unusable for me; for mission-critical project, go back to 2010 or 2007? Hel

    Excel 2010 is compatible with Excel 2007 in that the 2007 workbook will work just fine with Windows 2010. Uninstall Office 2013 and install Office 2010.

    I am using Excel 2010 64 bit on a computer that predates Win 7 and don't have problems so, if your hardware isn't real ancient, you should be ok.

    Describe your problems with Conditional Formatting more completely and supply a sample file representative of the workbook and we can try and help you iron out the problems that you face.

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window (or use the paperclip icon).
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ 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. Replies: 0
    Last Post: 03-04-2016, 03:49 PM
  2. Excel 2007 works but not 2010 or 2013
    By Miliano in forum Excel General
    Replies: 1
    Last Post: 10-02-2014, 03:20 AM
  3. [SOLVED] VBA compatibility issues: Excel 2007, 2010, 2013
    By AdLoki in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-29-2013, 07:01 AM
  4. Calendar Control for use with Excel 2007, 2010, and 2013?
    By Frankf in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-25-2013, 04:49 PM
  5. Replies: 4
    Last Post: 10-12-2013, 12:16 PM
  6. Windows 8, Excel 2013 and Project 2010 - Reference Error in Macro
    By microsoftexcel007 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-01-2013, 06:23 PM
  7. Replies: 3
    Last Post: 03-29-2013, 12:35 PM

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