dragging formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1679412%22%20slang%3D%22en-US%22%3Edragging%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1679412%22%20slang%3D%22en-US%22%3E%3CP%3EA%20and%20B%20columns%20having%20some%20values.%20wrote%20formula%20in%20C%20column%20with%20comparison%20of%20A%20and%20B%20columns%20But%20formula%20is%20not%20dragging%20and%20after%20sometime%26nbsp%3B%20some%20another%20column%2C%20dragging%20the%20cell%20also%20not%20working.(ex%201%2C2%2C3%20etc).%20i%20googled%20and%20checked%20some%20auto%20options%20but%20still%20facing%20the%20problem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1679412%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1679441%22%20slang%3D%22en-US%22%3ERe%3A%20dragging%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1679441%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F778499%22%20target%3D%22_blank%22%3E%40rajeshmanepalli987%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20is%20difficult%20to%20truly%20diagnose%20your%20problem%20without%20seeing%20an%20example%20of%20the%20formulas%20and%20data%20that%20you%20are%20working%20with.%20Perhaps%20you%20could%20share%20a%20sample%20of%20your%20data%3F%20(please%20remove%20any%20sensitive%20data%20of%20course)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

A and B columns having some values. wrote formula in C column with comparison of A and B columns But formula is not dragging and after sometime  some another column, dragging the cell also not working.(ex 1,2,3 etc). i googled and checked some auto options but still facing the problem.

 

3 Replies
Highlighted

Hello @rajeshmanepalli987,

 

It is difficult to truly diagnose your problem without seeing an example of the formulas and data that you are working with. Perhaps you could share a sample of your data? (please remove any sensitive data of course)

Highlighted
Thanks for the reply. I will check it out tomorrow (UK Time), but I would add that the VBA code does not compile (debug + compile VBA Project). It is a standard spreadsheet of 100 sheets (eacha different Cost Centre and in each sheet there is an itemised listing of expenditure in this month against a Cost Centre.

The spreadsheet is created by Oracle e-Financials and has code in it that does not compile.

Does this help in any way?

All I could do is upload a couple of redacted images of the spreadsheet but I can only think that it is a compatibility issue between the version of the file, it not being an xlsm and Office 365. This is then counter-intuitive with it being copied to the desktop and being accessible.

Could it even be AD corruption of path and nothing at all to do with Office at all? But if the user logs into a pc with an older version of Office they can open the file!

I am totally confused.

Thanks for taking the time to reply.

Alastair
Highlighted

@AMacFarlane 

 

Apologies posted in wrong place!

 

Sorry!

 

Alastair