Excel calcs / formula problem

[paul.clarke]

I have created a form, a menu if you like. I have a command button set to open a specific excel spreadsheet that was origianlly created in excel, so it uses formulas such as "weeknum".
When i click on the button to open this on my access form, i get #name? instead of the weeknum. Is there anyway i can get this to show the weeknum as entire sheet uses this for forecasting. i have tried using format(now(),"ww") in the spreadsheet itself to replace weeknum(), hoping that when loaded from access it would work, but no luck,

thanks in advance

paul

 

[paul.clarke]

Have i explained this well enough to understand, or are people generally stumped on how to resolve?

 

[Dennisk]

try exporting the speadsheet, then importing it into Access. Or you could open the spreadsheet within Access and read the cells, to see if the problem with the Excel function persists

 

[paul.clarke]

That wont work, the spreadsheet is refreashable by entering data and it produces a forecast goin forward on rolling weeks, 12 weeks ahead, so i need the week number issue to work, or nothing will at all.