Depending on what information you manipulated in Excel before importing it back in may determine whether this would help or not.

The keys will be rebuilt automatically when you print the reports if Sales Analysis detects that a
key file it requires is not available when you decide to print a report or perform an export.

What the function does is inspect every report and export defined and builds the key files necessary to process the information correctly.

Because this could take a substantial amount of time if your Sales Analsys database is quite large, you should pick a time where this will not interfere with anything else you may have to do. You are normally only given this option after you have retrieved your OE data into Sales Analysis using the Retrieve Sales Data from Order Entry option.

I can tell you that when you are in the 'Edit Sales Analysis Data' option, when you are in the Invoice Number field at the top, you can press the down arrow to see a list of documents that are available to edit. You should see a list that is comprised of several entries for each document number. This is because each doc # that is the same represents one item on the invoice/credit note. If the first one you have selected (perhaps by just typing in the number) is not the correct one, go to the next one in the list to see if this contains the information you are looking for. Repeat this process until you have found the record you want.

It may help to know what kind of information you modified in Excel in order to answer your question more accurately, and if you have tried doing a data integrity check before and after the export/import.

Take care,