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 sending the …
Excel formula randomly changes to hard-code number
Feb 14, 2005 · I am having an issue with an Excel model that was orginally written by some of my predecessors at work. I do not know the complete history of the file, but it would be extremely time …
[SOLVED] Using dynamic file path instead of hard-coded - Excel Help …
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 forum answers …
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 basis. I …
How to make whole spreadsheet hard numbers and remove all formulas
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 I just do whole …
Conditional format to highlight cells that are hard ... - Excel Help Forum
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 yellow. Any …
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
Remove hardcoded Cell Reference and replace with ROW Function
Apr 17, 2023 · Forum Microsoft Office Application Help - Excel Help forum Excel General [SOLVED] Remove hardcoded Cell Reference and replace with ROW Function - How The use of AI tools (e.g. …
Changing Year Flag for Fiscal Year starting July - Excel Help Forum
Mar 20, 2017 · Our Fiscal Year starts every July. Any fixes to hard code Excel to recognize July as the "first" month going forward in Pivots? It always starts in January and it messes up my charts/graphs …
[SOLVED] DGET with a hardcoded array for "criteria" - Excel Help Forum
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. chatGPT, BARD, …