excel Problem
-
- Posts: 30
- Joined: Wed Feb 01, 2017 1:45 pm
have to try and describe the problem best i can,when i down load the templates for excel multi and single and then connect to the market i am interested in then put a new blank workshet in it automaticaly imports data and starts flashing.And every time i try to enter data with the = sign it starts flashing again. then after i enter data it will not update with time and price everything really anyone else had this problem?? or can anyone help as i cannot use it at the moment.....Thanks for any replies
sounds like you have this problem: viewtopic.php?f=19&t=15746&p=143918#p143918
you'll have to revert your excel to a previous update
you'll have to revert your excel to a previous update
- ShaunWhite
- Posts: 9731
- Joined: Sat Sep 03, 2016 3:42 am
You can't edit a spreadsheet while it's connected.
you can't? I do all the time
- MemphisFlash
- Posts: 2126
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
yes you can!
- ShaunWhite
- Posts: 9731
- Joined: Sat Sep 03, 2016 3:42 am
Well obviously it's physically possible, but if you're changing or referencing cells BA is populating then it's ify. Inadvisable too because if you forget to save it and close BA you don't get a save prompt and you lose your changes.
OK it's doable, but I don't think it's necessarily the best practice for someone who's unfamiliar with it so I was ruling out the grey area.
OK it's doable, but I don't think it's necessarily the best practice for someone who's unfamiliar with it so I was ruling out the grey area.
- ShaunWhite
- Posts: 9731
- Joined: Sat Sep 03, 2016 3:42 am
I almost changed it to 'shouldn't' instead of 'can't' but for once I was trying to do a quick reply.
As sa7med mentioned, if you are using Excel 2016 (Office 365) then it sounds like you are suffering from a bug Microsoft introduced early this year:billposter wrote: ↑Sat Apr 07, 2018 3:18 amhave to try and describe the problem best i can,when i down load the templates for excel multi and single and then connect to the market i am interested in then put a new blank workshet in it automaticaly imports data and starts flashing.
You can rollback Excel to an earlier build by using the following in a command prompt:
pushd %programfiles%\common files\microsoft shared\clicktorun
officec2rclient.exe /update user updatetoversion=16.0.8730.2127