More Excel Issues

[dubs]

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!!!

[dubs]

I don't believe it! I had fixed the formatting and got it to work from TM1, accessed TM1 as a different user and its now calling the old sheet, I don't know where to start!!

anyone know what actually happens behind the scenes?

I would have assumed: You click the excel shortcut to open the sheet, that looks at its BLOB file to find the sheet in }externals and then opens that sheet? but apparently not!

[dubs]

think it may be calling versions from the windows temp directory, have to do a few tests first to confirm but cant work out what else it could be