Good morning
After working normally when I now open the HYP top up spreadsheet it opens in design mode and I cannot change it by toggling the design mode button on the developer ribbon ( it stays in design mode after being clicked) meaning I cannot click the buttons.
I have a related spreadsheet that logs my buys and the data from this is imported on opening into the spreadsheet and works fine.
My main machine is a windows VM on a MAC, but I have tried opening the spreadsheet on a windows machine and the same happens.
I have also downloaded a new copy of the spreadsheet from the web site and that opens also in design mode.
I am now stuck. What Am I doing wrong ?
Regards
Colin
Problem with excel and top up spreadsheet
-
- Posts: 29
- Joined: November 17th, 2016, 7:48 pm
-
- Lemon Quarter
- Posts: 3865
- Joined: November 4th, 2016, 9:24 am
-
- Posts: 29
- Joined: November 17th, 2016, 7:48 pm
Re: Problem with excel and top up spreadsheet
Sorry
Should have said I had already googled that solution and have tried even setting the macro level to low and it has no effect
Regards
Colin
Should have said I had already googled that solution and have tried even setting the macro level to low and it has no effect
Regards
Colin
-
- Lemon Quarter
- Posts: 3865
- Joined: November 4th, 2016, 9:24 am
Re: Problem with excel and top up spreadsheet
What happens if you try http://lemonfoolfinancialsoftware.weebl ... crape.html
If that works, it suggests the problem is related to HYPTUSS, if it fails it suggests a problem with your Excel installation
--kiloran
If that works, it suggests the problem is related to HYPTUSS, if it fails it suggests a problem with your Excel installation
--kiloran
-
- Posts: 29
- Joined: November 17th, 2016, 7:48 pm
Re: Problem with excel and top up spreadsheet
I had considered it was a problem with the installation within the VM which was why I tried it on a bare metal windows installation and it had the same problem (even after changing the macro setting).
The bare metal windows version is Excel 2013 and the VM is using excel 365 windows version.
Will try downloading and report vbakc again
Thanks for your help so far
Regards
Colin
The bare metal windows version is Excel 2013 and the VM is using excel 365 windows version.
Will try downloading and report vbakc again
Thanks for your help so far
Regards
Colin
-
- Lemon Quarter
- Posts: 3865
- Joined: November 4th, 2016, 9:24 am
Re: Problem with excel and top up spreadsheet
When you tried it on your pukka Windows machine, did you use your modified HYPTUSS or a freshly-downloaded version?
--kiloran
--kiloran
-
- Posts: 29
- Joined: November 17th, 2016, 7:48 pm
Re: Problem with excel and top up spreadsheet
ok
downloaded the scrape on the windows macghne --Worked
downloaded new copy of HYPTUSS to windows machine and imported the raw data -- worked
Saved copy of that sheet and then used it on the windows VM on MAC - worked.
Will now make a further copy of the SS and try to add my customisation to see if it works ( will report back but not for some time as I am goingg away for a few days)
Thanks again
Colin
downloaded the scrape on the windows macghne --Worked
downloaded new copy of HYPTUSS to windows machine and imported the raw data -- worked
Saved copy of that sheet and then used it on the windows VM on MAC - worked.
Will now make a further copy of the SS and try to add my customisation to see if it works ( will report back but not for some time as I am goingg away for a few days)
Thanks again
Colin