I am interested in finding out if a form can be used as the source of linked data to an Excel spreadsheet. The appearance and layout of the data appears differently than if I use a Table as the source via Cut and Paste Special Links method. The form, however, does not allow the linking option.
Thank you. cft

A form is simply an organized way of looking at data in a recordset built from either a table or query. It does not in itself store any data. Try to rephrase your question as I cannot picture what exactly you are trying to do.

Thank you, Pat.
I have a table of refund data that needs to be available to a customer service group to respond to customer inquiries about status. What I need is the data sequenced from newest to oldest, top to bottom of the Excel spreadsheet. The Table in Access, when exported to Excel is formatted correctly, but not linked to reflect updates in Access. The Table, when Copied and Paste Special - Linked sequences the data opposite of what I need even though the Table is ordered correctly in Access. I know this is probably simple, but I cannot seem to work my way around this. Any help will be welcome. Thanks.

Relational tables are unordered sets of data. The only way to ensure a predictable sequence is to use a query with an order by clause. You can create a query that orders the data the way you want and export that to Excel rather than the table. This process does NOT create a permanent link from the spreadsheet back to the database. Therefore changes to the table will not be reflected in the spreadsheet. To make an active link, you need to do it from Excel rather than from Access so you can tell Excel that you want the link to be updated when the spreadsheet is opened. You probably can do this from Access via OLE automation but that will require VBA code. If you wanted to use OLE to automate Excel, you would need to use the Excel help files for direction. You would not find any detailed help for this in the Access help file.