Is there a way to make a workbook link to an entire table in Excel Web?

Hi @R0502, 

Thank you again for your interest in automating your Excel Web setup to keep your staff-facing workbook updated. I truly appreciate your proactive approach and the clarity you've provided about your team's needs. 

To support your scenario, I’ve shared both an Office Script and a Power Automate flow that can help copy your Gastro table from the source workbook to a destination workbook on a regular schedule. These tools are designed to work within Excel for the Web and are available here: 

This script copies a table from a source worksheet and pastes it into a target worksheet, replacing any existing content in the destination range.   

Note: This script must be run in the destination workbook. 

The source workbook must be accessible and open in the same session.   

function main(workbook: ExcelScript.Workbook) {

// Define the name of the source workbook and table

const sourceWorkbookName = "SourceWorkbook.xlsx"; // Change this to your source workbook name

const sourceWorksheetName = "Sheet1"; // Change this to the sheet containing the table

const sourceTableName = "Gastro"; // Change this to your table name

// Define the name of the destination worksheet

const destinationWorksheetName = "StaffView"; // Change this to your destination sheet name

// Get the destination worksheet

const destinationSheet = workbook.getWorksheet(destinationWorksheetName);

// Clear existing content in the destination sheet

destinationSheet.getUsedRange()?.clear();

// Get the source workbook and worksheet

const sourceWorkbook = workbook; // This assumes the source table is in the same workbook

const sourceSheet = sourceWorkbook.getWorksheet(sourceWorksheetName);

// Get the source table

const sourceTable = sourceSheet.getTable(sourceTableName);

// Get the range of the source table

const sourceRange = sourceTable.getRange();

// Get the values from the source table

const values = sourceRange.getValues();

// Get the destination range starting at A1

const destinationRange = destinationSheet.getRangeByIndexes(0, 0, values.length, values[0].length);

// Set the values in the destination range

destinationRange.setValues(values);

}

Moreover, if you'd like to move forward with the Power Automate flow, I strongly recommend visiting the Power Automate Community Forum: Find Answers | Microsoft Power Platform Community 

Since forum moderators have limited permissions and access to internal resources, the community forum is the best place to: 

• Get hands-on support from experts who can test your flow. 
• Receive tailored advice based on your setup. 
• Explore solutions that go beyond what we can provide directly. 

They have the tools and environment to simulate your scenario and offer the most accurate and effective guidance. 

Thank you again for your patience and for choosing Microsoft Q&A forum. Please let me know if there’s anything else I can assist you with. I’m here to support you every step of the way.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment”.    

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.