G
glenlisa
Have run into a problem using excel - it is telling me the formula I a
using is too long and will not allow additional data to be entered. Th
excel file is a payroll where worksheets are used to calculate the pay
That information is then transferred to the Master worksheet (gros
summary) then certain fields within the worksheets are selected as par
of the formula on the master. All worked fine until now when trying t
add infomation to the formula due to additional worksheets being adde
... the comment formula too long will not allow additional data an
therefore unable to get the master sheet to balance.
The formula being used is as follows
=Eyears!C16+Eyears!C19+Eyears!C22+ and picks up data from another 30
employees. Any help / suggestions would be appreciated
using is too long and will not allow additional data to be entered. Th
excel file is a payroll where worksheets are used to calculate the pay
That information is then transferred to the Master worksheet (gros
summary) then certain fields within the worksheets are selected as par
of the formula on the master. All worked fine until now when trying t
add infomation to the formula due to additional worksheets being adde
... the comment formula too long will not allow additional data an
therefore unable to get the master sheet to balance.
The formula being used is as follows
=Eyears!C16+Eyears!C19+Eyears!C22+ and picks up data from another 30
employees. Any help / suggestions would be appreciated