differently

  1. S

    Application.ConvertFormula behaves differently

    Hi All, I have below macro, which works on my PC. On another PC, the same code behaves differently. Any ideas why this is different, we both run Excel 2016? Sub setFixedCol() 'Hotkey: Ctrl + Shift + U Dim c As Range For Each c In Selection If c.HasFormula Then c.Formula =...
  2. W

    Excel and one drive

    I have several workbooks on our network that have linked cells to each other. I wanted to move them to One Drive so I can access from anywhere but the links break. Is there a way to avoid this? Need I link it differently than the standard copy past link?
  3. Geeta2014

    MS Excel>Options>Advanced>When calculating This Workbook: Permanently Deselect Update Links to OtherDocuments

    Many questions: 1) Does this option behave differently in different versions of Excel? 2) Does it matter whether it is on Window 7 or Windows 7 or should it behave the same on both 3) Microsoft Help only explains the feature but offers no assistance on how to permanently deselect it by using...
  4. J

    simple pivot table question

    On right is the pivot table output I am looking for. Each row contains the date and things are being grouped by the second column: campaign. On the left, however, is a new one I am trying to set up to mimic the one on right but is just formatted differently and I can't figure out what the...
  5. A

    How does Excel treat numerics differently

    I am testing one value as a multiple of another and suspect that they are stored differently. I have a routine accumulating money values in various denominations. There is a text box for each coin denomination ( eg 50 cent,20 cent, 10 cent etc) called tb10cents, tb20cents etc. I wish to prevent...
  6. Aladin Akyurek

    Who's Online

    behaves now differently. Is this intended?

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top