Gridlines in MS Excel

[scotman]

A program that I use writes a file which is readable in MS Excel. This imports fine and all data is present. One thing it does is eliminate the on-screen gridlines in all cells which have data.
I have gone into Page Setup | Sheet and ticked the box also gone via Tools | Options | View tab and set gridlines on with colour set to automatic.
None of the above have got my gridlines back.
What do I do next?

Thanks

[ChuckFickens]

are you sure it's not importing it all into one cell

what is the format of the file from the other program? CSV, tab delimited, an other?

[scotman]

Chuck

Thanks for the reply.

The import is fine. As regards format, I don't know, There is a button which exports data in MS Excel format and another which does CSV. We always use the Excel one. Maybe try the CSV and import that into Excel as an alternative.

[scotman]

Chuck
Update in case you come back here.
Possibly I should have said that the direct export to Excel is exactly that. The output prog starts Excel and writes the data into it. You then see an open spreadsheet called Worksheet1 appearing in your taskbar with the data present.
The CSV option writes the file to disc and then you have to import to Excel manually. I tried that today and got what I wanted. I don't know if it has anything to do with the tweaks that you can do when importing or not.
I still don't see why I could not fix the directly written version though.

[VHG]

Microsoft have LOADS of forums for support.

Why not try here for example

http://answers.micros...ce/default.aspx#tab=1