I have a sales workbook, that contains links to other sales workbooks. I update this several times a day by closing out of the workbook, reopening it, and enabling the content, which pulls anything that has changed from those workbooks that are linked. Is there a way to leave my workbook open and "enable content" over and over again without closing and reopening it?
Would a hard recalc not work (Ctrl+Alt+F9)?
Have you tried selecting the Data Ribbon and selecting Refresh All, or Connections | Refresh All?
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks