Solved: it only needed the office updates by IT department...I coulnd not find the solution earlier.. Thanks! L
Hi Mynda, What is confusing is that nothing has changed at all. The source data is created just once, nothing changed - file is closed. Table9 is ...
Thank you, it is good to know! I really like coming here asking for advice, my membership will expire soon, it is sad that I wont be here much longer...
I tried your suggestions but unfortunately didn't work.. the message still pops up. There seems to be a VBA code to handle it but I am now more curio...
Hi Mynda, True, I tried by refreshing the query itself and the message did not appear at all - thank you! But I would like to use 'Refresh ...
Aha!! Thank you, Mynda.
Ideally I'd like only authorized users to be able to refresh the query. There were times that the queries were refreshed by others before finalizing ...
Thanks Catalin, I re-do the header, it works but column B in the original table has moved to column D in appended table (highlighted in orange) and I ...