Hi, there is a couple of levels of security you have to modify in the later versions of Excel, such as Macro security (Excel Options > Macro Settings)and Trusted sites (Excel Options > Microsoft Office Excel Trust Center > Trust Center Settings ...) to get the conversions macros to run automatically. 2003 did not have the extra layer of security, thus why BMC recommend it.
Cheers Carl http://www.missingpiecessoftware.com/ -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jamie Sent: 28 June 2012 18:04 To: arslist@ARSLIST.ORG Subject: Data Management Client on Windows 7 Has anyone installe the Data Management Client on a Windows 7 workstation with excel 2010? By default the application installed in the 32 bit Program Files (x86) folder, and even though when I'm trying to use the DMT tool for foundation upload and I select the correct path to for the DMT install, the worksheets are not opened and converted correctly. For some reason the worksheet is opened with a hard value of the DMT install path of /Program Files/ instead of /Program Files (x86). Has anyone had any luck getting the Data Management Client to work with Windows 7? I tried opening a ticket with BMC and after two weeks of going back and forth they said it was part of the design and excel that to be 2003. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"