Change pivot table to values but keep formatting - Excel Help Forum
Nov 21, 2016 · Hi All, I have a pivot table in excel 2007. I'd like to use copy-paste special-values over the top of it to get rid of the pivot table and data link, but keep the formatting, before …
How to make whole spreadsheet hard numbers and remove all …
Feb 2, 2023 · I want to make all of my data hard numbers, remove formulas or all reference values, similar to Copy and special paste but without doing it with copy and special paste, can …
Excel formula randomly changes to hard-code number
Feb 14, 2005 · Re: Excel formula randomly changes to hard-code number One way to make sure all macros are disabled is to open excel in Safe mode: Windows start button|Run Excel /safe …
[SOLVED] Using dynamic file path instead of hard-coded - Excel …
Aug 20, 2018 · Microsoft Office Application Help - Excel Help forum [SOLVED] Using dynamic file path instead of hard-coded The use of AI tools (e.g. chatGPT, BARD, GPT4 etc) to create …
Adding a hard coded time (hh:mm) to the end of a DATE formula …
Jun 16, 2015 · Re: Adding a hard coded time (hh:mm) to the end of a DATE formula within the same cell What do you mean the time will be different in each cell? If you wanted to hard code …
[SOLVED] DGET with a hardcoded array for "criteria" - Excel Help …
May 7, 2013 · Forum Microsoft Office Application Help - Excel Help forum Excel Formulas & Functions [SOLVED] DGET with a hardcoded array for "criteria" The use of AI tools (e.g. …
Creating a Dynamic File Path Rather Than a Hard Coded One
Jun 23, 2020 · Hard code path to refresh data from a csv file By R.Baxter in forum Excel Programming / VBA / Macros Replies: 7 Last Post: 06-03-2009, 09:33 AM
Conditional format to highlight cells that are hard ... - Excel Help …
Feb 1, 2016 · I have cells with vlookups, index matches, etc, and I want to make a conditional format so that if the cell has just numbers (either a number or an equation), that it will highlight …
Hard code to current date [SOLVED] - Excel Help Forum
Dec 29, 2019 · Hard code to current date I manually enter data into a dashboard from a number of different apps. I then enter the data using copy and paste into a summary sheet on a daily …
Hard-code source data [SOLVED] - Excel Help Forum
Dec 29, 2005 · Re: Hard-code source data Hi Melanie If you do not want to use dynamic names and you do not mind a macro doing the job for you once a month, then... 1) Create a list of the …