Hi,

I have an excel file which is used as database of records for a year. As of now its size is 135MB and till Dec'12 I'll add data to this. But every time I open this file it takes too much time and sometimes it doesn't alow to save the changes made or hangs when try to execute some mass activity.

Please help what to do?

Regards,

Nikesh

What version of Excel are you using ?

Excel is NOT a database, transfer the data to a real database,

What version of Excel are you using ?

I use excel 2010

Excel is NOT a database, transfer the data to a real database,

Thanks for suggestion but it is not posible because other users don't know to use the access.

Thanks for suggestion but it is not posible because other users don't know to use the access.

Not a good answer. I develop Access databases for a living. I've written a book on it. The vast majority of my users have no clue how to use Access. They don't need to. I create menus, data entry forms and reports that they can use to enter and extract the data. Your users don't even have to have the full version of Access. You can deploy the free runtime version for users.

Excel is a great tool but it has its limitations. When you run up against those limits you have to move on to a different tool.

Right.. creating a database is the best method.make a user page with all the required fields for input and output.it will be a lot faster(your main problem solved).and it will be much more user friendly.

Not a good answer. I develop Access databases for a living. I've written a book on it. The vast majority of my users have no clue how to use Access. They don't need to. I create menus, data entry forms and reports that they can use to enter and extract the data. Your users don't even have to have the full version of Access. You can deploy the free runtime version for users.

Excel is a great tool but it has its limitations. When you run up against those limits you have to move on to a different tool.

What you have written is right but unfortunately not sutailble to me.

What you have written is right but unfortunatly not sutailble to me.

Why? Because you don't have the skills to develop something? Then farm it out. There are plenty of Access consultants who can develop something for you and it may not be very expensive. But the bottom line is it's the only way to fix what you are dealing with other than chop the file into smaller pieces.

Scott is right here.get it developed from outside.it will not cost much.we all need to increase the car size when the family size increases.
If you still want to use excel,use different files for different months.That should sort things out for you.

scott is right here.get it developed from outside.it will not cost much.we all need to increase the car size when the family size increases.
If you still want to use excel,use different files for different months.That should sort things out for you.

Thanks for your suggention.

I have got some alternatives..