Check out some similar questions!

nikeshtnt · Oct 19, 2012, 02:12 AM

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

Curlyben · Oct 19, 2012, 02:25 AM

What version of Excel are you using ?

ScottGem · Oct 19, 2012, 02:31 AM

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

nikeshtnt · Oct 19, 2012, 02:36 AM

Originally Posted by Curlyben

What version of Excel are you using ?

I use excel 2010

nikeshtnt · Oct 19, 2012, 02:38 AM

Originally Posted by ScottGem

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.

ScottGem · Oct 19, 2012, 02:49 AM

Originally Posted by nikeshtnt

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.

Rohin Arora · Oct 19, 2012, 03:54 AM

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.

nikeshtnt · Oct 19, 2012, 03:59 AM

Originally Posted by ScottGem

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.

ScottGem · Oct 19, 2012, 04:14 AM

Originally Posted by nikeshtnt

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.

Rohin Arora · Oct 19, 2012, 04:23 AM

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.

nikeshtnt · Oct 31, 2012, 10:24 PM

Originally Posted by Rohin Arora

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..