Posts: 2539
Joined: 3/4/2014
Location: Cottontown, TN USA
Edited Date/Time:
Because there is a melting pot of characters on this site... thought I would ask:
Are there any SharePoint users on here? I am having an issue loading a report in excel and not being able to see my stoplight indicators. Works in SharePoint, but I receive the code I use in excel instead of the indicator.
Thanks
Posts: 3259
Joined: 3/21/2016
Location: BFE, TX USA
My wife is a Sharepoint guru. I will show her this thread in a few hours and see what she says.
"We don't rent pigs."
Posts: 2539
Joined: 3/4/2014
Location: Cottontown, TN USA
Posts: 5508
Joined: 11/16/2011
Location: Menifee, CA USA
I'm no Excel guru, and I don't even know what SharePoint is, but are you copying the data in SP and pasting it into Excel? You may want to try "paste special/keep source formatting" or "paste special/paste link" if it references an external link.
Braaapin' aint easy.
Posts: 2539
Joined: 3/4/2014
Location: Cottontown, TN USA
Falcon wrote:
I'm no Excel guru, and I don't even know what SharePoint is, but are you copying the data in SP and pasting it into Excel? You may want to try "paste special/keep source formatting" or "paste special/paste link" if it references an external link.
Thanks Falcon. I am adding info to a custom list in SP and exporting to Excel. I added stoplight indicators (icon) in SP (red,yellow, and green) to reflect the status of the task.When exporting to Excel, I do not get the icon, but the code that was written in SP to produce the icon.
JAFO - thanks for the message and reaching out. I really appreciate it! I responded to the message, but please , y'all do not need to go out of your way to help tonight if its too late. I am already behind on the project... so my medicine is coming even if I don't find a resolution tonight.
