More Excel Issues
Posted: Tue Apr 05, 2011 10:33 am
something I really struggle with is the link between the excel sheet TM1 calls and the physical sheet on the disk
Once I have my sheet saved up to TM1 I often amend it straight from the }externals directory but find that sometimes I can make an amendment, then open it from TM1 and the amendment isn't there. I've tried bouncing the server and the admin server but its very unpredictable
for example: I had to change a number format on a sheet yesterday, made the change outside of TM1 and saved it, opened the sheet from TM1 and formatting hadn't been changed. opened the sheet from }externals and the formatting had been changed, bounced the server and reopened from TM1, formatting hasn't been changed, reopened from }externals and it has been changed - i seriously don't understand what is going on the BLOB files are pointing to the }externals folder and there is only one copy of the spreadsheet in that directory
its almost as if it is caching it somewhere but you would expect bouncing the admin and tm1 services would clear that cache
now obviously I could save it up to the server each time I make an amendment - this is a pain because it takes longer and also does funny things like creates a timestamped copy of the sheet in the }externals directory and points the blob to that.
anybody know what the hell is going on? it doesn't make sense to my easily confused brain!!!
Once I have my sheet saved up to TM1 I often amend it straight from the }externals directory but find that sometimes I can make an amendment, then open it from TM1 and the amendment isn't there. I've tried bouncing the server and the admin server but its very unpredictable
for example: I had to change a number format on a sheet yesterday, made the change outside of TM1 and saved it, opened the sheet from TM1 and formatting hadn't been changed. opened the sheet from }externals and the formatting had been changed, bounced the server and reopened from TM1, formatting hasn't been changed, reopened from }externals and it has been changed - i seriously don't understand what is going on the BLOB files are pointing to the }externals folder and there is only one copy of the spreadsheet in that directory
its almost as if it is caching it somewhere but you would expect bouncing the admin and tm1 services would clear that cache
now obviously I could save it up to the server each time I make an amendment - this is a pain because it takes longer and also does funny things like creates a timestamped copy of the sheet in the }externals directory and points the blob to that.
anybody know what the hell is going on? it doesn't make sense to my easily confused brain!!!