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.

Apr 2, 2015 · And so on. I'm trying to do this for a workbook with multiple worksheets of monthly values for mutual funds I own and another workbook (single worksheet) that shows asset allocation. So to …

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 This also means that, …

Nov 2, 2023 · For a long time, Python didn't work.When my Windows was recently updated, on first attempt, Python worked ... But only once!Now when I go to execute any Python code, it doesn't …

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 windows …

Feb 25, 2013 · I have to have 3 or 4 workbooks open at the same time with the same (named) macros in them. To make them work I use the WorkbookActivate event to assign keys to macros. e.g.: …

Feb 17, 2018 · BR BrandyTurner1 Created on February 17, 2018 Last Modified date per sheet in NON macro enabled shared workbook

Apr 13, 2012 · With Application .DisplayFullScreen = False .CommandBars ("Worksheet Menu Bar").Enabled = True End With End Sub As my Worksheet is Protected and the users uses 2003 I …

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.