How do I update the data sheet on HYPTUSS
I have downloaded the most recent version of the data sheet and it is now in my "Downloads" folder.
My HYPTUSS is on my desktop. How do I get the new data sheet into my HYPTUSS spreadsheet.
Sorry if this is a stupid question, but I can't work it out.
Thanks, norwichfool
Got a credit card? use our Credit Card & Finance Calculators
Thanks to Rhyd6,eyeball08,Wondergirly,bofh,johnstevens77, for Donating to support the site
How to update HYPTUSS data sheet
-
- Posts: 16
- Joined: December 15th, 2016, 10:32 am
- Has thanked: 15 times
- Been thanked: 6 times
-
- Lemon Slice
- Posts: 655
- Joined: August 31st, 2018, 9:08 pm
- Has thanked: 268 times
- Been thanked: 251 times
Re: How to update HYPTUSS data sheet
NorwichFool wrote:How do I update the data sheet on HYPTUSS
I have downloaded the most recent version of the data sheet and it is now in my "Downloads" folder.
My HYPTUSS is on my desktop. How do I get the new data sheet into my HYPTUSS spreadsheet.
Sorry if this is a stupid question, but I can't work it out.
Thanks, norwichfool
I open the new file, copy the contents of the Digital Look Data Sheet (click in any cell, then control + a) then paste in over the existing Data Sheet (careful to select cell A1 before pasting - control +v)
Hope this helps
-
- Lemon Quarter
- Posts: 4112
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3252 times
- Been thanked: 2855 times
Re: How to update HYPTUSS data sheet
EssDeeAitch wrote:NorwichFool wrote:How do I update the data sheet on HYPTUSS
I have downloaded the most recent version of the data sheet and it is now in my "Downloads" folder.
My HYPTUSS is on my desktop. How do I get the new data sheet into my HYPTUSS spreadsheet.
Sorry if this is a stupid question, but I can't work it out.
Thanks, norwichfool
I open the new file, copy the contents of the Digital Look Data Sheet (click in any cell, then control + a) then paste in over the existing Data Sheet (careful to select cell A1 before pasting - control +v)
Hope this helps
After the CTRL+A, you need a CTRL+C to copy to the clipboard. There is also a danger that perhaps the new version has fewer rows than the original, so I would suggest:
- If you are not 100% comfortable with these operations in Excel or LibreOffice, first make a copy of your HYPTUSS in case you corrupt the HYPTUSS
- Open HYPTUSS, then select the Digital Look Data Sheet
- CTRL+A to select all cells, then hit the Delete key
- In Excel (or LibreOffice), FILE/OPEN and select the new file digital_look_data_sheet.txt
- In the new sheet, CTRL+A then CTRL+C to copy all cells to the clipboard
- Select cell A1 in the HYPTUSS Digital Look Data Sheet, then CTRL+V to paste the data
- The file digital_look_data_sheet.txt can then be discarded.
--kiloran
-
- Lemon Slice
- Posts: 655
- Joined: August 31st, 2018, 9:08 pm
- Has thanked: 268 times
- Been thanked: 251 times
Re: How to update HYPTUSS data sheet
Ah, thanks for the correction kiloran, I knew that of course just forgot to put it in the post.
-
- Lemon Quarter
- Posts: 3574
- Joined: November 5th, 2016, 10:30 am
- Has thanked: 1 time
- Been thanked: 1191 times
Re: How to update HYPTUSS data sheet
I'm sure those of us who have added a few more exotics to the end of the datasheet know to copy those extras and append them when the updated sheet has been pasted.
I too think it is good practice to make a copy of your current HYP to try any changes on so there is a working earlier example to revert back to if you make a mistake.
I too think it is good practice to make a copy of your current HYP to try any changes on so there is a working earlier example to revert back to if you make a mistake.
-
- Lemon Slice
- Posts: 409
- Joined: November 4th, 2016, 10:43 am
- Has thanked: 185 times
- Been thanked: 156 times
Re: How to update HYPTUSS data sheet
Before you test it take note of the current Webfg problems as in this thread:
viewtopic.php?f=27&t=16060
Rob
viewtopic.php?f=27&t=16060
Rob
-
- Posts: 16
- Joined: December 15th, 2016, 10:32 am
- Has thanked: 15 times
- Been thanked: 6 times
Re: How to update HYPTUSS data sheet
Many thanks for replies. All done now. Shame Webfg is playing up today.
Return to “Financial Software - Discussion”
Who is online
Users browsing this forum: No registered users and 11 guests