Nightlytic
Member
Hi,
I have MS office 2010, 32 bit, windows 7. I have a presentation file that has maybe c.20 charts that connect to two excel files located on a network, pulling charts and tables (these are excel-linked chart objects). I need to update this regularly.
It takes a minute or two to just update one chart/table (right click and update link) and some excel pop ups come up and need to be OK'd. If I try to update the entire slideshow, excel goes berserk it pops up message after message 'open as read only', 'file caused error on opening last time, do you want to continue' etc. it does it more times than there are files I think it actually re-opens the excel file over and over for different charts. Spend 1 hour letting it work and OK'ing messages last night and then at the end I had to kill it because now excel started saying the file I'm trying to open is already open, and the message kept popping back up no matter what I said to that.
Any idea how to diagnose this, make a working presentation that connects to excel? It might be the fact I'm connecting across network to fetch the files? idk...
I have MS office 2010, 32 bit, windows 7. I have a presentation file that has maybe c.20 charts that connect to two excel files located on a network, pulling charts and tables (these are excel-linked chart objects). I need to update this regularly.
It takes a minute or two to just update one chart/table (right click and update link) and some excel pop ups come up and need to be OK'd. If I try to update the entire slideshow, excel goes berserk it pops up message after message 'open as read only', 'file caused error on opening last time, do you want to continue' etc. it does it more times than there are files I think it actually re-opens the excel file over and over for different charts. Spend 1 hour letting it work and OK'ing messages last night and then at the end I had to kill it because now excel started saying the file I'm trying to open is already open, and the message kept popping back up no matter what I said to that.
Any idea how to diagnose this, make a working presentation that connects to excel? It might be the fact I'm connecting across network to fetch the files? idk...