|
|
Rank: Newbie
Groups: Member
Joined: 11/29/2010
Posts: 9
Location: DK
|
Hi.
I have made a spreadsheet in Excel 2007, and it's been saved in .xlsm format because I have a few small macros. The sheet has a lot of trends on it, and it works perfectly, until I try to run it on everybody elses pc's. Then Excel, says, that TrendX can't be created because can't exit design mode. The sheet has been saved with design mode off.
I have NO idear what can cause this. The different PC's have the same software installed (version and all), and have the same rights.
We use Office 2007 and PI-lin 4.1.1
PLEASE someone help me out here !!!.
Best regards from.
Christian
|
|
|
|
|
OSIsoft vCampus is a subscription-based, online offering that consists of providing everything people need to develop applications on the PI System. We invite you to take a "tour" of the OSIsoft Virtual Campus - also feel free to consult the FAQ or contact OSIsoft vCampus for more details.
|
|
|
Rank: Member
Groups: Member
Joined: 5/24/2009
Posts: 11
Location: Wisconsin, USA
|
My first step would be to go to the Excel VBE on those computers, then Tools | References and see if any are missing. I have run into this many times on our corporate computers which are, of course, set up identically 
|
|
|
Rank: Administration
Groups: Administration
Joined: 6/20/2008
Posts: 617
Location: Cheshire, United Kingdom.
|
Hi Christian, I agree with mauth in that typically you would expect a file (not just the reference file) is missing or there is no access. From the error message you get the "TrendX" part of the message, is "X" an index number of the trend (e.g. "Trend1") you added or is it called "TrendX"? Either way, is that the valid name of a trend that is displayed on your worksheet or is it a trend that you once added then deleted? You might need to use some VBA to find it and delete it and try distributing your workbook again. Otherwise, one option would be to copy all the objects & data from your workbook to another, new workbook. Sometimes Excel just gets it's knickers in a twist... Principal Consultant
Real-Time Data Management @ Wipro Technologies
|
|
|
Rank: Newbie
Groups: Member
Joined: 11/29/2010
Posts: 9
Location: DK
|
Hi. Thanks for your answers. When I refere to "TrendX" it referes to e.g. "Trend1" the error comes several times, and referes to 3 or 4 trends, and I know that 3 of the trends are there. I have had trouble to locate one of them. How can that be done ?, can I use the count code you showed me last week ? The references also got me thinking, that I just might have a reference that I have forgotten about, from another project, but it's not used in this project ! I will get back tommorrow, when I get back to work, and have been looking more into this. Best regards from. Christian RJK Solutions wrote:Hi Christian,
I agree with mauth in that typically you would expect a file (not just the reference file) is missing or there is no access.
From the error message you get the "TrendX" part of the message, is "X" an index number of the trend (e.g. "Trend1") you added or is it called "TrendX"? Either way, is that the valid name of a trend that is displayed on your worksheet or is it a trend that you once added then deleted? You might need to use some VBA to find it and delete it and try distributing your workbook again.
Otherwise, one option would be to copy all the objects & data from your workbook to another, new workbook. Sometimes Excel just gets it's knickers in a twist...
|
|
|
Rank: Newbie
Groups: Member
Joined: 11/29/2010
Posts: 9
Location: DK
|
Hi.
Well after hours of trying, I got the spreadsheet working on other PC's. What I had to do was saving it as a XLSX file (was XLSM) then open it on one of the other PC's, then adding the macros and VB code again, then saving it as an XLSM file again. Now it all works, until I open it on my PC and saves it (without changing anything), then it will not work on other PC's anymore !, so it there must be something wrong with MY PC. So for now, I'm using another PC to finish this project.
I think there are alot of issues with Excel 2007. Sometimes, when I open the spreadsheet, all the text formatting is just GONE, and I have to make it again. We also have other spreadsheets, running 24/7, where we have to reboot almost once a day, because the PC's runs out of memory, eventhough, we don't store any data in them, and they are just showing some PI trends !
Best regards from.
Christian
|
|
|
Rank: Newbie
Groups: Member
Joined: 11/29/2010
Posts: 9
Location: DK
|
Hi All. I finally solved the problem, by reading and using the temp file deleter located here http://www.add-ins.com/temp_file_deleter.htm
Might help someone else  Best regards from. Christian
|
|
|
|
Guest
|
