jb
Member
Hi Helpers,
I have one excel file which is created to manage timetable of one educational institute.
It contains many excel sheets.
Main worksheet is timetable. It contains many slots. Each slot has two lines - upper line is for subject and below line is for faculty name.
Master timetable is available in some another file. (In future, I want to keep everything in one excel file.)
Previous day, I copy master timetable of next day and make necessary updation. Because, as faculty may go on leave or faculty may not be available in the assigned slot.
So sometimes the sessions are required to be shifted in another slot. So, when I try to shift two cells (subject and faculty name) to another place, it takes lot of time. Blue circle keeps on displaying on screen for considerable amount of time which delays my updation process.
Now, many worksheets are there, which is updated from timetable sheet. formula sheet contains all calculation.
I am not in a position to remove any worksheet as all contains required funcionalities. Rather, I may need to add some more functionalities in future.
Please help me to make my file faster. My sheet is working perfectly. Only speed is an issue.
I have one excel file which is created to manage timetable of one educational institute.
It contains many excel sheets.
Main worksheet is timetable. It contains many slots. Each slot has two lines - upper line is for subject and below line is for faculty name.
Master timetable is available in some another file. (In future, I want to keep everything in one excel file.)
Previous day, I copy master timetable of next day and make necessary updation. Because, as faculty may go on leave or faculty may not be available in the assigned slot.
So sometimes the sessions are required to be shifted in another slot. So, when I try to shift two cells (subject and faculty name) to another place, it takes lot of time. Blue circle keeps on displaying on screen for considerable amount of time which delays my updation process.
Now, many worksheets are there, which is updated from timetable sheet. formula sheet contains all calculation.
I am not in a position to remove any worksheet as all contains required funcionalities. Rather, I may need to add some more functionalities in future.
Please help me to make my file faster. My sheet is working perfectly. Only speed is an issue.