I recently gave up on the obtaining share price battle and capitulated to MS 365. It works reasonably well for price look ups but this is now the year end for me where I live. In the past I merely saved a fresh copy of the workbook, tidied it up and started with a fresh one for the new year. I removed the data links on the old workbook which kept it as is a record of the previous year.
I have just got to the stage of trying to remove the data links from the old workbook MS 365 version - they won't go. Anyone know how I can do this?
GN.
Got a credit card? use our Credit Card & Finance Calculators
Thanks to gvonge,Shelford,GrahamPlatt,gpadsa,Steffers0, for Donating to support the site
Share prices in Excel MS 365
-
- Lemon Quarter
- Posts: 1097
- Joined: November 4th, 2016, 1:12 pm
- Has thanked: 179 times
- Been thanked: 377 times
Re: Share prices in Excel MS 365
GN100 wrote:I recently gave up on the obtaining share price battle and capitulated to MS 365. It works reasonably well for price look ups but this is now the year end for me where I live. In the past I merely saved a fresh copy of the workbook, tidied it up and started with a fresh one for the new year. I removed the data links on the old workbook which kept it as is a record of the previous year.
I have just got to the stage of trying to remove the data links from the old workbook MS 365 version - they won't go. Anyone know how I can do this?
GN.
If you are trying to freeze the price information, just copy the cells and then paste the values back -Copy/ Paste Special/ Value. That will break the reference to the Share Data Type. If you want to turn the Share Data back to Text, then Right Click / Data Type / Convert to Text.
-
- Lemon Slice
- Posts: 913
- Joined: November 6th, 2016, 2:15 pm
- Has thanked: 143 times
- Been thanked: 336 times
Re: Share prices in Excel MS 365
I do pretty much the same thing in Excel (Not MS365).
If I understand what you are trying to do, I highlight all the share prices I want to keep and copy those then I "Paste Special" that data back into the same cells and choose "Values".
That keeps the share prices as they were but loses the links.
Hope that makes sense and works for you.
If I understand what you are trying to do, I highlight all the share prices I want to keep and copy those then I "Paste Special" that data back into the same cells and choose "Values".
That keeps the share prices as they were but loses the links.
Hope that makes sense and works for you.
Return to “Financial Software - Discussion”
Who is online
Users browsing this forum: No registered users and 5 guests