i have an important query. i am searching google for a slolution i couldnt find. hope somebody here can help.
i am working on a excel sheet now, it contains multiple rows and columns. There is one column in the file which is linked to other files in my laptop. Consider i am working on a file called Summary. there is a column called Last update. this collumn is linked to multiple files in my laptop. that is am dealing with a number of projects and each projects has a tracker file. and these tracker files are linked to the Summary file. and whenever i make a change in the tracker it automatically updates in my summary sheet. the problem is this is okay when i work in my laptop. but this summary file is shared with my project manager. and this file is shared in onedrive. but my manager is not able to view the Last update column as it is showing some error. now what exactly am looking for is that, i want excel to create a pdf file automatically whenever i make any change in the summary sheet.
is that possible??
please let me know with detailed steps.
Thanks in advance
By: Abdul Majeed