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

0 Members and 1 Guest are viewing this topic.

oxmo

  • Newbie
  • *
  • Posts: 7
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: 3219
  • 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 2007 Std