Good Afternoon All,
So let me be the first to dust off my login, it's been quite a while since I've posted anything here. I just wanted to say that thank you for posting all of your great posts in here as I've got all sorts of great answers from this forum.
My turn now, my HR department have developed this 60 MB XLSM Spreadsheet and are having all sorts of gremlin/problems with it now. It was working fine up until about 3 months ago. It pulls data from a database and puts it into an SQLDATA sheet in the workbook. They then link to that data in different sheets.
They are using Excel 2010 on a Windows 7 Professional platform.
The first problem that's popped up is that when they delete or remove a row from the spreadsheet, it corrupts the spreadsheet and we are unable to get it working again without going to a backup.
Next problem is, some of the sheets have comments in them with mostly pictures in the comments fields. What they notice now is sometimes they will make a change and something happens in the spreadsheet and all of the comments disappear.
Anyways, I honestly haven't worked to get my knowledge up to snuff with their spreadsheet but, I'm sure it must be something in the sheet that's causing it to wig out.
Looking to you gurus out there to shed some light on the situation.
Thanks
Evan
So let me be the first to dust off my login, it's been quite a while since I've posted anything here. I just wanted to say that thank you for posting all of your great posts in here as I've got all sorts of great answers from this forum.
My turn now, my HR department have developed this 60 MB XLSM Spreadsheet and are having all sorts of gremlin/problems with it now. It was working fine up until about 3 months ago. It pulls data from a database and puts it into an SQLDATA sheet in the workbook. They then link to that data in different sheets.
They are using Excel 2010 on a Windows 7 Professional platform.
The first problem that's popped up is that when they delete or remove a row from the spreadsheet, it corrupts the spreadsheet and we are unable to get it working again without going to a backup.
Next problem is, some of the sheets have comments in them with mostly pictures in the comments fields. What they notice now is sometimes they will make a change and something happens in the spreadsheet and all of the comments disappear.
Anyways, I honestly haven't worked to get my knowledge up to snuff with their spreadsheet but, I'm sure it must be something in the sheet that's causing it to wig out.
Looking to you gurus out there to shed some light on the situation.
Thanks
Evan