#NAME? Error When Opening a Saved File

[tarantula]

Good morning!

I've got a bit of an issue, in our office we use a file that's created using Opera XRL, which basically pulls in data from our sales and stock management system, to show stock movements.

The report runs fine, then is saved. When myself or the person who runs it opens it, it appears fine. However when anyone else opens it they get #NAME? all across the sheet.

Tried changing other people from auto calc to manual calc, and no joy.

Any ideas?

 

[Andrew Poulsom]

I expect the workbook contain functions that aren't avaialable to the other users because they don't have Opera XRL. You will need to convert those formulas to values before you distribute the workbook.

 

[tarantula]

Thanks Andrew, I had said this would be the solution, but just thought I'd get a second opinion. The report was fine for years but recently Pegasus came in to update it.. only change other than this I noticed was a few coloured rows