AsparagusLady
New Member
- Joined
- Dec 16, 2016
- Messages
- 9
Dear super-clever folks - please help!`
I have a spreadsheet for recording and analysing accident data - it contains several sheets, drop-down look-ups from named ranges, tables, pivots...but no macros.
Said sheet keeps developing odd little habits and I am at a loss as to what is going on!
Some of the intermittent problems:
I've changed the book from xlsm to plain old xls. It warned me that certain elements (VBA Projects) couldn't be saved in this format - but there are no VBA projects.
I'd appreciate any ideas on what's causing my gremlins - I'm going spare!
I have a spreadsheet for recording and analysing accident data - it contains several sheets, drop-down look-ups from named ranges, tables, pivots...but no macros.
Said sheet keeps developing odd little habits and I am at a loss as to what is going on!
Some of the intermittent problems:
- When saved, the file saves a copy of itself beginning with '~$'
- When opened, dialog box saying 'This workbook already contains data, are you sure you want to overwrite it?'
- A colleague is inputting information, saving the file, then when he re-opens the data isn't there
I've changed the book from xlsm to plain old xls. It warned me that certain elements (VBA Projects) couldn't be saved in this format - but there are no VBA projects.
I'd appreciate any ideas on what's causing my gremlins - I'm going spare!