Hi, I work for a small recruitment firm and we dont have much IT support, we work from 2 very basic excel spreadsheets (no macros, formulas or filters) which are shared by 3 computers, but only saved one one - One with our staffs names, telephone...
Hi,
I work for a small recruitment firm and we dont have much IT support, we work from 2 very basic excel spreadsheets (no macros, formulas or filters) which are shared by 3 computers, but only saved one one -
One with our staffs names, telephone numbers and availability - Size 878KB, 4 pages, largest 157 Rows X 26 Columns
The other showing what work we have outstanding and booked in - SIze 89, 810KB, 8 pages (Months) average 500 Rows X 18 Columns
These files regularly get too large so we usually have to maintain these files approx every 3 months by starting 2 new files and in the case of the 1st file copying and pasting all info directly in and the 2nd one we copy the layout, some info and limit it to no more than 6 months and a few spare sheets.
This method worked fine untill recently, now the files are very slow, often freeze or crash and most importantly, we now regularly have chunks of vital info missing in the morning when we log in, even though everything was there when we saved and left the previous evening (we have ruled out human error)
This is causing major problems when we come to do our staffs wages, we have tried other methods to keep our records, but the layout that its in works far better than anything else we've tried, if only we could get it to work!
I would be gratefull for any help with excel or suggestions of other programmes as we are now having to take print outs every night and re enter large chunks of info every morning.
Many thanks
Jo
Linear Mode
