Strange goings on with Excel
#1
Scooby Regular
Thread Starter
Join Date: Oct 2000
Location: the fastest rentals in town......0-100mph in 10 seconds
Posts: 1,401
Likes: 0
Received 0 Likes
on
0 Posts
I've had to work with two very basic spreadsheets which list entries from A-Z. The first sheet covers entries A-K and the second L-Z. Each letter is represented on a different sheet with 6 column headings.
Both sheets have around the same number of entries but sheet 1 is nearly 2mb and sheet 2 is just 137k. Nobody has noticed this before but it's p1ssing me off working with something of this size when it's clearly not required.
There are no macros, I've tried copying the data to a new workbook but it carries overthe cause - whatever it may be.
Anyone have any suggestions?...
FIA
Both sheets have around the same number of entries but sheet 1 is nearly 2mb and sheet 2 is just 137k. Nobody has noticed this before but it's p1ssing me off working with something of this size when it's clearly not required.
There are no macros, I've tried copying the data to a new workbook but it carries overthe cause - whatever it may be.
Anyone have any suggestions?...
FIA
#2
Scooby Regular
iTrader: (1)
Sounds like u got alot of unused cells in sheet 1 (ie used in the past n then deleted), highlight all the cells not needed and do, edit/clear all on the blank cells, resave, n see if that makes a difference. If not then delete the rows with the blank cells, using shift on the 1st empty row+end/home to select all, delete.
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM
Jonny mac
ScoobyNet General
10
09 October 2015 12:25 PM
bluebullet29
General Technical
9
05 October 2015 02:17 PM