UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Problem With Names, Office 2007    
 
   
Ice929rr
post Jul 10 2014, 09:35 AM
Post#1



Posts: 218
Joined: 19-July 06
From: Lisbon - Portugal


Hi all,
I have several charts in PowerPoint 2007 linked to an Excel 2007 file.
In order to keep everything up to date, I created in the Excel file many Names (using Name Manager) .
The problem is, when I open the PowerPoint presentation and “refresh” all of the Names in the Excel file, some of the names are with problem
Turning this
=Dashboard.xlsm!DPC_MDATA1
to this
=[0]!DPC_MDATA1
Is there a way to resolve this?
Tks in advance
Luis
Go to the top of the page
 
ADezii
post Jul 10 2014, 10:52 AM
Post#2



Posts: 1,857
Joined: 4-February 07
From: USA, Florida, Delray Beach


This is just a Shot-in-the-Dark, but Powerpoint may see the .xlsm (Macro Enabled Workbook), as a Security Threat and essentially disable the Link. Check, and possibly modify, your Security settings in Powerpoint.
Go to the top of the page
 
Ice929rr
post Jul 11 2014, 02:50 AM
Post#3



Posts: 218
Joined: 19-July 06
From: Lisbon - Portugal


Hi,
will take a look at those settings and get back to you later.
Tks
Go to the top of the page
 
Ice929rr
post Jul 11 2014, 05:14 AM
Post#4



Posts: 218
Joined: 19-July 06
From: Lisbon - Portugal


Nope, still not working...
Cheers
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    16th December 2017 - 06:09 AM