Having a problem with Export To Excel, cannot export my main address book to an Excel file. I do get the dialog box that says the file has been exported.
I can export other grids to to an Excel file with no issues.
Comments
Hi Al,
You can use Copy / Paste instead. You can also create an .ODC link if you wish.
I suspect it is because the grid has not been made visible to other applications (Grid > Properties > Options). In v70, I'll add a test and option to make it visible (same as .ODC file)
The "Visible to other applications" wasn't checked on the other grids which were able to export to Excel. If I remember correctly I was able to Export to Excel the AddrsBook grid a couple of weeks ago.
I checked the " Visible to other applications" on the AddreBook, and it did export to an Excel file but I no longer get the sub-levels for any of the Items or the Item number which I want. The font also changes to MS Sans Serif. The checkbox fields now show TRUE/FALSE instead of 0's and 1's. It looks like a text file.
How would I get the Export to Excel to behave like it was before I checked the "Visible to other applications"?
Comments