Bartender using Excel as a lookup file

[PhilSM]

My company use a program called Bartender which is a barcode printing program.
Bartender has the ability to extract information from an Excel sheet which is really useful and prevents repetetive keying in of information.
We have found that if you simply print the Excel sheet when Bartender next uses the file it says it is corrupt and simply copying the data into a new spreadsheet and resaving it as the same name does not resolve this issue.
I know this is a very specialised and possibly non Excel query but if anyone else has come across this you help would be very much appreciated.

Does anything change in Excel when you print it ?

[Cheeky Charlie]

Yes - accessing the print preview page and/or printing causes Excel to define soft print boundaries if they don't already exist. I'm afraid I don't really understand more than this fleeting overview. I could guess that the print layout information is causing 'Bartender' problems. Perhaps you could save your Excel files as csv to strip extraneous information (drop down at the bottom of the 'save as...' dialogue) - let us know if that works

HTH

[shg]

Seagull says on their web site,

Free Support for BarTender
We make BarTender as intuitive as possible and include a thorough and easy-to-use help system. Then we stand behind it with free technical support from a thoroughly trained worldwide support team.

I'd put them to the test.

[PhilSM]

Thank you for both replies Cheeky Charlie and shg.
Unfortunately Bartender needs the file to remain .xls so cannot change this.
We have tried using the Bartender support but this route has proven to be somewhat fruitless, but thank you for your suggestion.