unexpected event

  1. U

    Unexpected Excel restore loses all modifications

    While editing, Excel restored the workbook and I lost all changes. Since Excel did not crash there was no recover file to retrieve the data. Has anyone seen this unexpected event before? This had never happened before while working with Excel for a long time and seemed to just start like some...
    • u144644
    • Thread
    • data loss excel unexpected behavior excel2016 restore unexpected event
    • Replies: 0
    • Forum: Excel Questions
  2. C

    Range.Delete causes unexpected Click event

    Good, bleary-eyed, morning folks, Today's conundrum is that using Range.Delete(xlUp) is causing unexpected _Click events (two in fact) in a ListBox. I have a named range, "List", covering $A$3:$A$7 which is used in the box's ListFillRange property and as data in the Sub UpdateList. A second...
    • CPerdue
    • Thread
    • listbox click non-basic code range.delete unexpected event
    • Replies: 2
    • Forum: Excel Questions
  3. P

    Formula array in VBA causes subroutine to exit

    Hi, I'm trying to implement to use an array formula to take a value and find the smallest difference from a list of known values. The array formula works fine when I manually input it: ' =MIN(ABS($A$5:$A$502-E5) ' + CTRL-SHIFT-ENTER and when I record this using the macro recorder I get the...
  4. H

    Hyperlink Changes

    Opened a spreadsheet (Excel 2003) I use frequently with numerous hyperlinks in it - almost all pointing to files elsewhere on my C: drive - to find that every hyperlink has been "readdressed" (with the correct filename) to the Excel folder buried in Documents and Settings/Username/Application...

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