T
Ticotion
Hi
I have a database where I link to an excel sheet where the next 12 months
are shown as the header. So every month the header will shown the following
12 months.
ex. this month the header look like this
Forecast 01-10-07 01-11-07 01-12-07 and
so on.
next month it looks like this
Forecast 01-11-07 01-12-07 01-01-08 and so
on
The problem is that the link tabel in access doesn't reflect the change to
the excel file. Instead og writting 01-01-08 it writes F12 which I guess is
an default name. How can you get access to always reflect the headers in the
Excel sheet without creating the link from the beginning every time?
regards
Ticotion
I have a database where I link to an excel sheet where the next 12 months
are shown as the header. So every month the header will shown the following
12 months.
ex. this month the header look like this
Forecast 01-10-07 01-11-07 01-12-07 and
so on.
next month it looks like this
Forecast 01-11-07 01-12-07 01-01-08 and so
on
The problem is that the link tabel in access doesn't reflect the change to
the excel file. Instead og writting 01-01-08 it writes F12 which I guess is
an default name. How can you get access to always reflect the headers in the
Excel sheet without creating the link from the beginning every time?
regards
Ticotion