tag:blogger.com,1999:blog-7650953985627040991.post928095410064726218..comments2024-02-14T05:30:55.538-05:00Comments on Cameron's Blog For Essbase Hackers: Stupid Excel Linked Workbook TrickCameron Lackpourhttp://www.blogger.com/profile/07701786303677521318noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-7650953985627040991.post-17743204882999916332014-07-09T15:26:34.984-04:002014-07-09T15:26:34.984-04:00Thank you! QQ...what if your source workbook is i...Thank you! QQ...what if your source workbook is in a "table" format? I have a source sheet that has over 30 columns and 2000 rows and I do not want to individually link each cell but just be able to copy and paste over...but everytime I do this it links to only the initial table cell i linked to.<br />='Source Sheet.xlsx'!Table1[[#This Row],[COLUMN NAME]]Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-25351432647312234312013-11-22T10:29:53.216-05:002013-11-22T10:29:53.216-05:00Interesting post. In all of my years of using Exc...Interesting post. In all of my years of using Excel I've always thought of linking cells to other workbooks as just an PITA and have never embraced the practice. I cringe when I see people linking workbooks together (as a client did just yesterday). <br /><br />Oh well...<br /><br />JoeJoe Watkinsnoreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-13124474108496134282013-11-21T12:59:19.022-05:002013-11-21T12:59:19.022-05:00Ha, this was an enjoyable read and Im sure will sa...Ha, this was an enjoyable read and Im sure will save my hide some day. My head is still spinning trying to digest the Microsoft explanation. Thanks Cameron!Drew Coluccinoreply@blogger.com