Aug 22, 2024 · How can I paste the date and time from another workbook and prevent excel from changing the date to 1/0/1900? This is the data I'm copying from a spreadsheet I received.

I closed a workbook in excel and when I opened it back up a tab was gone? I have tried the restore versions and previous version aren't there.

Jun 23, 2025 · How do undo an action only in my current spreadsheet? Undo from single workbook only, with multiple workbooks open Undo when several files are open in Excel 2010 …

Jan 28, 2015 · You can try the following. If the workbook is open then Save and close it. Close Excel. Backup your workbook as follows. Create a new folder in windows explorer While still in …

Sep 27, 2015 · How to make This Workbook default for Record Macro "Record Macro" default is "New Workbook", how can it be changed to "This Workbook"? Sometimes I end up with two or …

Mar 6, 2020 · The free Excel workbook "Professional_Compare" (updated) is available at MediaFire. (compares every cell in two worksheets Or each row in one worksheet against all …

Mar 30, 2016 · I have an Excel workbook (Workbook 1) that contains pivot tables that use data from a different workbook (Workbook 2). Both workbooks are shared with colleagues on Dropbox.

Apr 20, 2012 · I have created a macro that loops through all files in a subdirectory and pulls info I need. I would now like it to skip the workbook if it doesn't include a tab with a specific name. …

Sep 4, 2021 · I will send a private message to collect the workbook. You can save the workbook to your computer and then upload it in the private message or create a duplicate workbook in …

Feb 8, 2018 · Sheet.Protect VBA script breaks sharepoint co-authoring? Hello. I have macro enabled workbook that has a protected sheet and shared in SharePoint 2016. Everything …