links between worksheets

Hi, Note: I'm not a VB expert or even a beginner, so I may get the wording wrong so apologies and thanks in advance: Background: I have 2 x sheets, called: • Master: This is a front menu page that all users see that contains an image (4 Pillars) as per the example: • Each Pillar...

I have a sheet that works perfectly fine. When I edit the links to new work sheets and save it as a new file name, everything works fine. Then when I reopen the sheet, I get warning that excel has found unreadable content in the document. When I click yes, it repairs sheets, but removes all of...

I have a large number of files which include cells linked to a Summary sheet. I need to add some rows to the Summary sheet but in doing so I notice that the cells of the linked files do not pick up that the original link location has shifted. I have experimented using both the eg. A%5% format...

I am creating a template in Excel 2007 to collect data from the field for creating sales proposals. (WB1) Using another Excel 2007 Workbook (WB2), I point to a specific template ["edit link" to] "WB1" for throughput to a MS-Word Proposal. Question: How can I link to an image (specifically the...

Afternoon folks, I've got a list of files in Column A of a sheet (path and filename), with a modified-date in column B and file-size in column C. For each item in the list, I want to open the file in Column A, break the links to other workbooks, save and close the file, then return the new file...

Hello all, I am trying to complete a custom reporting solution and need to open and extract data from multiple files in a folder. However, when the file is opened, I get a pesky dialog box about the file having links that cannot be updated. These links are leftover from the tool that...

Is the only way to reference another worksheet cell is with an absolute path name ('C:\...\...\..)? I need to figure out the best way to make this "portable" to other users. I have a workbook which contains multiple tabs, each one with product pricing in different geographies (about 20 tabs...