F
funkymunky420
data is imported to a closed excel workbook from access
the data is manipulated and stored in another worksheet.
I have linked the results sheet to my access db.
The problem.
The linked excel work sheet does not update, I have tried using the link
table manager.
The only way the linked excel worksheet updates is when i open up the
workbook save it then close it down.
I would like to know of a way to update the linked sheets without having to
open up the excel workbook
thanks
the data is manipulated and stored in another worksheet.
I have linked the results sheet to my access db.
The problem.
The linked excel work sheet does not update, I have tried using the link
table manager.
The only way the linked excel worksheet updates is when i open up the
workbook save it then close it down.
I would like to know of a way to update the linked sheets without having to
open up the excel workbook
thanks