Skip to Content
author's profile photo Former Member
Former Member

BPC V7.0 and compatability with Windows 7 and/or Excel 2007

Hi

We are running BPC Version 7.0.118 with MS Server 2003. I recently upgraded my PC to Windows 7 and Office 2007 after having first installed SP9 and we were assured this is what was needed to run Windows 7. I am the only user accessing the server over the local network - all other users access via Citrix.

However - I am now getting regular occurences of my machine locking up completely, and always when I have open Excel 2007 and BPC, and the only solution is to completely reboot my machine.

We thought at first it was a network issue because this had the effect of locking up all other users on the same hub, but we have isolated my machine onto its own hub and eliminated a faulty ethernet cable being a possible problem. When my machine is disconnected from the hub without rebooting, the hub is unlocked after switching it off/on, then when my machine is reconnected it locks the hub again which all points towards a problem on my machine and specifically an issue with 2007 / Windows 7 and compatability with BPC. I am also having problems making changes in BPC since the change to Windows 7/Office 2007 - simple additions to dimension members process and refresh OK but then when I come to use them in input views (even adding them in to existing input schedules that I know are OK) I get "EVDRE encountered a problem retrieving data from the web server". Also when I save .xlt files to the server I get 'cannot access read-only document [File name].xltTemp' messages... but when I try to save again it works OK.

I guess the simple question is whether anyone else has a similar set up and faced the same problems? Does this point towards BPC version 7 not being compatable with Windows 7 and/or Excel 2007? We have other users using both but they access via Citrix...

Many thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Apr 13, 2011 at 02:50 PM

    BPC 7.0 has supported Excel 2007 from the very beginning (SP3 was the official first release in Feb 2009) and started supporting Windows 7 as of SP08. The tricky part of Windows 7 support for BPC 7.0 is that BPC 7.0 requires .Net 1.1 SP1 and Microsoft no longer supports .Net 1.1 in Windows 7, but you can still install it. So if you are trying to use BPC 7.0 SP9 in a Windows 7 environment, please make sure you have a minimum of .Net 1.1 SP1 and apply any Windows updates to .Net 1.1 SP1. Make sure you do NOT upgrade to Internet Explorer 9 as it is not supported. Of course also make sure Windows in general is up to date, as well as Office 2007. It should have SP2 applied and all current updates. Double check your Macro settings in the Trust Center in Excel, and set your macro security to "Disable all macros with notification" and also place a check in "Trust Access to the VBA project model."

    If Excel continues to crash, it might be a worthwhile exercise to re-image your computer and reinstall Office completely. I know that's a drastic measure but we have plenty of clients using BPC 7.0 SP8 or SP9 with Windows 7 and like I said earlier, Excel 2007 has been supported for two years now with BPC 7.0.

    So, overall I think my recommendation is to first verify you have .Net 1.1 SP1 installed (not just 1.1), which would equate to a minimum version number of 1.1.4322.2032. That can be found here:

    http://www.microsoft.com/downloads/en/details.aspx?FamilyID=a8f5654f-088e-40b2-bbdb-a83353618b38

    If you didn't have SP1 installed, I would uninstall the BPC client before you update .Net. Same thing would apply if there were any major Excel updates needed (like adding SP2). The other thing you could do make sure the BPC Excel client is installed fully is to browse to your BPC server using Windows Explorer on your Windows 7 machine, find the client installer (EverestClient.exe) inside the folder location \BPC\Websrvr\web\installation, right click on the client installer file and choose "Run As Administrator." That will ensure that the client installs completely.

    Hopefully some of this helps!

    Brian

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks Brian

      We will have at look at all of your suggestions and see if we can get a resolution. I am also going to fire the issue at our implementation partner to see if they have experienced similar issues with other clients. Alternatively we may have to set me up with a Citrix connection as those other users don't seem to get the problems I am getting

      Regards

      Gary

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.