trouble with Excel and HYPTUSS
Posted: June 11th, 2023, 10:48 am
I'm reluctant to call for help as this seems quite difficult to explain.....
At present I cannot use my usual PC so I am reduced to a laptop with a more recent version of Excel which runs my saved HYPTUSS in "compatability mode". As far as I can tell, the Excel version calls itself "Excel 2010" and my original file is 2003. It will function, but cannot save.
To get round this, I downloaded the latest HYPTUSS, added some ITs and ran the spreadsheet. This saves OK. I then copied and pasted three shares from my HYP, added the number of shares and ran the get the prices. All OK and this also saved.
I then had a working HYp for my ITs, and one for the ITs plus three company shares. (Just to note, I run ITs and shares on separate spreadsheets).
Now the task was to add all my ordinary shares and delete the ITs. I added three more ordinary shares and the holding quantity. Now the spreadsheet refuses to save
I've tried adding via the "add" button or adding just one share, but thatr makes no difference.
I am really bugged by this. How is it I can save my ITs plus three shares, but when I add more in the same way, I cannot save it?
I guess the fundamental problem is that my laptop has a version of Excel which is not compatible, but as it's a later version than my PC which is positively ancient, I thought it would be more likely to run.
Any workarounds would be useful, but when all said and done, it only means a limited time before I can run the pc again.
At present I cannot use my usual PC so I am reduced to a laptop with a more recent version of Excel which runs my saved HYPTUSS in "compatability mode". As far as I can tell, the Excel version calls itself "Excel 2010" and my original file is 2003. It will function, but cannot save.
To get round this, I downloaded the latest HYPTUSS, added some ITs and ran the spreadsheet. This saves OK. I then copied and pasted three shares from my HYP, added the number of shares and ran the get the prices. All OK and this also saved.
I then had a working HYp for my ITs, and one for the ITs plus three company shares. (Just to note, I run ITs and shares on separate spreadsheets).
Now the task was to add all my ordinary shares and delete the ITs. I added three more ordinary shares and the holding quantity. Now the spreadsheet refuses to save
I've tried adding via the "add" button or adding just one share, but thatr makes no difference.
I am really bugged by this. How is it I can save my ITs plus three shares, but when I add more in the same way, I cannot save it?
I guess the fundamental problem is that my laptop has a version of Excel which is not compatible, but as it's a later version than my PC which is positively ancient, I thought it would be more likely to run.
Any workarounds would be useful, but when all said and done, it only means a limited time before I can run the pc again.