You can modify the way PDF is generated or produced if you manage or administrate software that generated PDFs automatically. For this, you must take care of the fact that no irrelevant bytes should appear before %PDF at head of PDF file.
If it don’t work the document is lost for good.
Perhaps this authoritative source will also help you.
https://forums.adobe.com/message/69… See less

Did you scan a document into Word with a scanner?

Now do you wish to edit the scanned document?

If I am correct you will need to use OCR (optical character recognition) software to scan the document then copy and paste the content into Word for editing.

Snapfiles hosts some good free OCR software. Here’s a link for you to look through:

http://www.snapfiles.com/downloadfi…

I just realised that Telugu characters may not be supported by some software. There is one that uses the Google Tesseract engine to decipher the image into text. This one may work for you

message edited by btk1w1

See less

You missed a step. A UDF doesn’t work unless there is VBA code behind it. Think of it this way:

When you use any built in Excel function, e.g. SUM, there is some internal programming behind it, buried deep within Excel. The nice folks that wrote Excel provide that programming for you.

When you create and use a User Defined Function, you, the user, are responsible for providing that behind the scenes programming.

You are getting a #NAME error because Excel doesn’t recognize the function PrevSheet as a valid function. You would get the same error if you entered any “function name” that Excel doesn’t know what to do with, e.g. =HappyBirthday(A1)

However, if Excel can find some programming behind the function name, it will (hopefully) return the value that the user wants the function to return.

That programming is done with Excel VBA – Visual Basic for Applications. VBA is a programming language that allows users to do things with Excel that go way beyond the built in functions. The set of instructions that are written in VBA are often called a Macro. The main difference between a Macro and a UDF is that a Macro is run either manually or automatically via a specific action taken by a user while a UDF can be run by including the name of the UDF in a formula.

Read up on Excel VBA and/or Excel Macros for more info.

OK, all that said, what you want is a Function that will always return the name of the previous sheet based on where the function is used. Since Excel doesn’t have a built in function to do that, we can use a UDF. Here’s how:

1 – Follow the first 3 steps at the link below to open the VBA editor and insert a Module.

https://www.wikihow.com/Create-a-Us…

2 – Once that Module is open, Paste the VBA code shown below into the window. That VBA code is the programming behind the UDF. The code first determines what sheet it is used in and then returns the name of the previous sheet, returning the value in the cell that you use in the formula, e.g. A1.

Function PrevSheet(rCell As Range)
    Application.Volatile
    Dim i As Integer
'Determine the sheet number of the sheet that called the UDF
    i = rCell.Cells(1).Parent.Index
'Subtract 1 from the current sheet number to reference the previous sheet
    PrevSheet = Sheets(i - 1).Range(rCell.Address)
End Function

3 – Now go back into your sheet and try the formula I suggested, which has the PrevSheet UDF in it.

Just like any Nested formula, Excel will see the UDF called PrevSheet and run the programming that is behind it.

One more item:

Since the workbook will now contain some VBA code, you will need to save the workbook with the .xlsm file type.

How To Post Data or Code —> Click Here Before Posting Data or VBA Code

See less

The lease time indicates, at what time your computer got the ip address assigned to.
When the lease expired is reached, and the computer has not used the ip address til that time, it gets released to use for other computers.
So when you turn on the computer, that had assigned this ip address, and it was released already, it gets a new ip address of the address pool.

Nothing, you have to worry about. Quite normal thing.

But, when you put in the gateway ip address to your internet browser and login to your router, you should be able to figure out your online status.

If the router shows, that there is no connection to your ISP, you have to call your ISP, that’s right.

If your router is connected to the internet, you got an in house issue, where I guess, your ISP won’t or can’t help you.

See less