would you help combime and auomatically comlete all my workbooks and make my presentation.

To combine your workbooks into a single workbook using Power Automate, you can follow these steps:

1. Sign into Power Automate and create a new Instant cloud flow.
2. Choose Manually trigger a flow and select Create.
3. Get all the workbooks you want to combine from their folder by adding an action and choosing the OneDrive for Business connector's List files in folder action. Use the file picker to select the "output" folder.
4. Add an action to run the Return worksheet data script to get all the data from each of the workbooks using the Excel Online (Business) connector's Run script action.
5. Finally, add an action to run the Add worksheets script on the new Excel file you created to add the data from all the other workbooks.

For optimizing your Excel workbooks, consider the following tips:

• Look through your workbook for memory-intensive formulas like LOOKUP, INDIRECT, and OFFSET, and try to reference only the necessary cells instead of whole columns.
• Limit the use of calculations across workbooks, as this can slow down performance.
• Clean up temporary files and check for excessive controls on worksheets that may affect performance.

These steps should help you combine and optimize your workbooks effectively.

Hello Tim,

Thank you for reaching out and sharing the challenges you’re facing with combining and optimizing your workbooks I understand how overwhelming it can feel when multiple tasks pile up especially when you need everything completed and ready for a presentation. The reason this happens is that managing several workbooks manually can be time-consuming and prone to errors which is why automation can make a big difference.

One alternative solution you can try is using Power Query in Excel Power Query allows you to import data from multiple workbooks into a single consolidated file without needing to write complex scripts. You can open Excel go to Data select Get Data select From File select From Workbook, and select each workbook you want to combine. After loading the data, you can use the Append Queries feature to merge all tables into one. This method is efficient, keeps your data structured and makes it easier to refresh when source files change.

For optimization review your formulas and replace volatile functions like INDIRECT or OFFSET with direct cell references where possible. Also remove unnecessary formatting and check for hidden objects or excessive controls that may slow performance these steps will help improve speed and stability.

I hope this answer is helpful if you have further questions feel free to reply back

Regards,

Marcelo