Hello, I have a weird problem with excel tonight. I wrote a macro on a new spreadsheet last WE and contrary to my former spreadsheets, the API create data links( tik ) only if the id is 1,10,100,1000,10000.... It doesn't work for all other id numbers. I have been watching options and cells format but can't find what is different from my former spreadsheets. The id is in a cell formula like : "=myname|tik!id8?bid" I was just hoping someone got this problem before cause i don't see where the problem is. Thanks in advance.