Author Topic: Paste special Excel; Visio Security Notice  (Read 2992 times)

0 Members and 1 Guest are viewing this topic.

oxmo

  • Jr. Member
  • **
  • Posts: 10
Paste special Excel; Visio Security Notice
« on: October 28, 2016, 09:12:26 AM »
Good morning all,

I've been lurking this forum for a long time now and was always able to find someone else with the same problem, but not this time.
At work we use Excel to make tables that we then copy and paste special in Visio.
After this is done, we are no longer able to modify fonts of the Visio drawing or modify the Design\Theme because we get a pop-up window.
I'm not talking about the font of the Excel table, but fonts in Visio (Ctrl+2).
We get a pop-up window:
Microsoft Office has identified a potential security concern.
This file (0) contains links to other files.
  • if you update the links, Visio will attempt to retrieve the latest data.
  • If you don't update the links, Visio will use the previous information.
Then I have 2 button options "Update Links" or "Cancel"
Both buttons basically does the same thing, nothing, as far as I know.
We get the same pop-up message when we save the file or when we open a file that contains a paste special link to Excel.
So here's more details:
  • We work on a server, but I've tried to copy all files to my local HDD and that doesn't fix the problem
  • I have Windows 7 Pro 64-bit
  • Office 2013 Pro 32-bits
  • Other colleagues have Windows 10 and Office 2016 and it's the same error
  • That wasn't an issue with Office 2010
  • I've tried the Regedit HKEY thing: https://support.microsoft.com/en-us/kb/925757
  • "File\options\trust center settings" does nothing
  • we use template files, but I've tried with fresh clean blank drawing and new Excel as well and still the same pop-up
  • I'm VBA illiterate, but I can probably get someone here to figure how to decipher a VBA solution, but I would rather have a simpler answer like uncheck this box

Thank you for your time!

gtakla

  • Newbie
  • *
  • Posts: 3
Re: Paste special Excel; Visio Security Notice
« Reply #1 on: March 13, 2017, 03:25:00 PM »
I have the same issue for months .. any help is appreciated ...

Brad Brown

  • Newbie
  • *
  • Posts: 1
Re: Paste special Excel; Visio Security Notice
« Reply #2 on: February 13, 2018, 05:11:07 PM »
I am having the exact same problem and have done a lot of research into it with NO results. Anything new discovered?

wapperdude

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 3622
  • Ideas Visio-lized into solutions
Re: Paste special Excel; Visio Security Notice
« Reply #3 on: February 13, 2018, 06:00:02 PM »
I don't have any of those Visio versions,cos cannot directly address this issue.  But, I am wondering if this might be a work-around...Visio ought to let you create an Excel file, once that's created, try a copy paste of the contents from your original file.  That is, don't paste the file, but rather, a copy of the cells from that file.

Just quick thought.
Wapperdude
Visio 2019 Pro

flormage333

  • Newbie
  • *
  • Posts: 2
Re: Paste special Excel; Visio Security Notice
« Reply #4 on: April 17, 2019, 09:05:00 AM »
I have been experiencing the same issue.  I have just found a solution to it this morning that is super simple.  Why this setting is related to the special paste links, I am not certain.

If you go into options > General, and uncheck the box "Enable Live Preview"  this will alleviate your issue.  At least it did for my company!  This setting just lets you see changes before you commit to them (ie previewing font colors)


Please let me know if this solution works for you.

MacGyverRick

  • Newbie
  • *
  • Posts: 1
Re: Paste special Excel; Visio Security Notice
« Reply #5 on: August 02, 2019, 05:33:13 PM »
Yes! Your solution flormage333 fixed the problem. I went into File > Options > General, and unchecked the box "Enable Live Preview".

wapperdude

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 3622
  • Ideas Visio-lized into solutions
Re: Paste special Excel; Visio Security Notice
« Reply #6 on: August 03, 2019, 09:40:03 PM »
With Win10, V2019Pro, Office10, having the Live Preview enable makes no difference.  Either way works as expected.  So, I still believe this is an Office and not a Visio issue.  Nice to have a simple work-around though for those who have Office16. 

Anyone try this with Off 2013, Off 2019?
Visio 2019 Pro