Jul 23, 2011 · Is there a way to convert a table back to plain text eliminating all the table formatting? That is, eliminate the fill colors, but preserve the number formatting. I know I can …

Aug 23, 2010 · I have a series of pivot tables in Excel 2013, and try as I might I cannot get the formatting to stick, in particular this is borders and text alignment. I have read tons on the net …

Sep 20, 2023 · To select all the table rows including the heading do one of the following: Keyboard method Select a cell in the column you want to change formatting of. Hit …

Aug 22, 2002 · My problem: this code sees the "Undo" as another Worksheet_Change event so it runs again. So the code is stuck where it cannot get out unless the user responds "Yes". How …

Jan 17, 2014 · Hi I have a problem when I refresh a pivot table. When I do that I lose all the number formats (comma style, negative numbers between brackets and in red etc). Both, …

Oct 6, 2020 · Hi, I am trying to share a workbook for users to edit and change data. It all works fine but when I click on "Share" I get message saying "Shared workbooks do not have access …

Jul 26, 2010 · How to set a default template in Excel Excel has the ability to use a custom template for all new workbooks. If you find yourself making the same changes to new …

Feb 12, 2003 · Churchy, I am using Excel 2007 & have used the code many time now without any problems. The only suggestion I can make is to check that the code is located in the workbook …

Jun 18, 2009 · I have a Workbook with 'data' tab and a power query to extract only some required info from this table in the same workbook. When someone is looking at the report produced by …

Mar 23, 2004 · From Application.Undo method (Excel) This method undoes only the last action taken by the user before running the macro, and it must be the first line in the macro. It cannot …