settings

Hi All, I have a spreadsheet with a formula I tried dragging down, and even though it copies the formula correctly, the results remain the same in the entire column. I tried F9 / checking formula settings were set to automatic but that did not sort the problem either. Anyone able to help? Thanks!

Excel 2016. I'll be darned if I can get 6 worksheets to print double sided except for one method. I've tried using my printer settings when using the Print function. Even if I select double sided it prints one page at a time. I even selected both tabs to be active. The only way I found this...

Hello Hello... Is there a reason for this or perhaps I'm missing something in the settings?

Dear All, I changed the pivot data settings. But after refresh it resume its original position. How does change so that after refresh it wont affect changed format. Any assistance !!! Rgds, aligahk04

Hello, I have a spreadsheet that I developed on a Windows 7 computer, with an English OS and Swiss German keyboard. Regional settings are for Swiss German keyboard and number format. This file is shared amongst a large group of people around the world. In it, there is a range with a simple...

Hi all, I've read the sticky post about signatures, buuuut the Signature bit doesn't seem to be in the Settings section anymore. Can anyone suggest how to add one, please? Thanks! Alice

Hello people, I am looking for a solution to save a file as CSV file with Always the same settings for list separator, decimal separator and thousand separator. If I run the macro from my computer the file will be as it should be because my local settings in Windows 10 are Decimal=, ...

Hello, how can I change Excel's printer settings so that every time I open a new workbook, the settings to print are always set to Landscape and the scaling is always set to Fit All Columns on One Page? I'm using Excel 2010. Please help, thanks.

Hi I would like to be able to use the standard MsgBox button argument settings to pass a value to a custom message box form that I have developed. For example : vbYesNo : 4 vbRetryCancel : 5 vbCritical : 16 and to be able to combine them as required. For example : vbYesNo + vbCritical...

Hi This message "Apply these changes to all other cells with the same settings" is in the Data Validation window. Why and What is used for? Thank you.

Hi all, I am have issues saving a workbook in a different location as a backup to the original however when using the code below I am finding that some of the detail is being lost. Can anybody help with the code as I can see there are various settings that can be chosen. ActiveWorkbook.SaveAs...

https://imgur.com/8mHIMxQ Hello, I struggled trying to figure this out. I am trying to get the percentage of "This over Last". I made the pivot table combining different factors so the percentage on Data is not accurate. Can I get the right percentage by changing some settings?

Hi there, Recent issue I've noticed in pivot tables in Excel 2013. When I go to explode data I am getting different results than I want. <colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody> Row Labels Claims Open Claims New Claims New Ind New Lit New...

This may or may not be a simple question. But how do I add a row (with assigned formulas) so that the formulas are automatically applied to the new cells, without having to drag the cell down myself. Also how can I make the new row copy the other row's merge settings? Thanks in advance.

How can I limit notifications to only when I receive a PM. I really don't care to receive notifications when someone quotes my thread or likes my thread. These are an annoying addition to the last upgrade. I will go to settings to see if anyone has responded to a thread that I have subscribed...

I'm currently using the following code (inside a much larger code) to print all worksheets that are named with a 5-digit code .... For Each ws In ThisWorkbook.Worksheets If ws.Name Like "#####" Then ws.Range("P22:U22").Font.Color = vbWhite ws.Range("P22:U22").Interior.Color...

Hello, I pull regular raw data, and one of the columns is the date formatted as follows: <colgroup><col></colgroup><tbody> 01/08/2017 0:00 02/08/2017 0:00 03/08/2017 0:00 03/08/2017 0:00 18/08/2017 0:00 </tbody> Usually, I can use =int() to extract the date, and format it to display...

The following code was tested in Excel 2013, with the macro settings at option 4, ie Enable all macros (not recommended; potentially dangerous code can run). Option Explicit Private Sub Workbook_Open() Application.OnKey Key:="^n", Procedure:=vbNullString End Sub...

I built a workbook which is intended to be a GUI (of sorts) for another program. In order to give the user the ability to add/remove/update inputs/outputs to the program I've made the spreadsheet configurable. By which I mean, on a given worksheet they're allowed to adjust the...

This is my first time posting a question, because I've always been able to find pre-existing answers in the past - thank you! My issue is hard to describe but I'm sure the solution is maddeningly simple: I have a spreadsheet with data in Column A, and a formula that references it in Column B...