Very odd excel problem
Thread Starter
Join Date: Oct 2000
Location: Sunny Sussex
Posts: 778
Likes: 0
Received 0 Likes
on
0 Posts
Very odd excel problem
I'm using Office 2003 version of excel. I have a large spreadsheet that is used as a job recording document. It has about 18 columns & the no. of rows grows by the day as jobs are recorded.
I have used this document since 2003, every year, I just remove all the rows, rename it 200x and carry on. No problem.
This week, it has started duplicating rows. I have no idea why. There are no macros or vb on it, just a few simple formulae to add up, subcontract and calculate percentages.
I haven't made any changes to it as a spreadsheet & yet each morning when I fire it up, I find the last few jobs entered are duplicated.
Any ideas why this might be happening?
I have used this document since 2003, every year, I just remove all the rows, rename it 200x and carry on. No problem.
This week, it has started duplicating rows. I have no idea why. There are no macros or vb on it, just a few simple formulae to add up, subcontract and calculate percentages.
I haven't made any changes to it as a spreadsheet & yet each morning when I fire it up, I find the last few jobs entered are duplicated.
Any ideas why this might be happening?
Not exactly sure as to what you mean by 'duplicating rows', but Excel is known over time to corrupt its own files if they are used frequently enough.
Could I suggest copying all the values, formulae and formatting to a new workbook (have 2 separate Excel sessions open on your PC) and saving the new file ? You might also find that the new workbook can be saved to disk with a smaller file size
Could I suggest copying all the values, formulae and formatting to a new workbook (have 2 separate Excel sessions open on your PC) and saving the new file ? You might also find that the new workbook can be saved to disk with a smaller file size