How to find my page in classmates. How to find a nonexistent page in classmates

Oh, non-existent links! You open a workbook and you see a message asking you to update your links - but you don't have any links! How can you update something that doesn't exist?

External links are links pointing to other books. Unexpected xrefs can appear for a variety of reasons, ranging from moving or copying charts, chart sheets, or worksheets to another workbook. But knowing that external links exist does not always help you find them. Here are some ways to deal with the problem of non-existent links.

First you need to find out if the book contains real external links (existing) that you just forgot about. If you're not sure if there are any, start by looking in the most obvious place - in formulas. To do this, make sure no other books are open and search for key phrase [*] in formulas on all sheets. Close all other workbooks to ensure that all references in formulas contain [*], where the asterisk is a wildcard character.

Excel 97 does not provide the ability to search an entire workbook, but you can search all sheets in a workbook by grouping them. For this right click mouse click the tab of any sheet and in context menu choose the Select All Sheets command. In later excel versions the Find and Replace commands provide the ability to search within a sheet or book.


When you search for references in formulas, change or delete the corresponding formulas. The decision to change the formula or delete depends on the specific situation, and only you can decide which way to go. Alternatively, you can head to the Download Center Microsoft Office (Microsoft Office Download Center) located at:, and in the Add-Ins category, select Delete Links Wizard. This utility is designed to find and remove references such as specific name references, hidden name references, chart references, Microsoft Query references, and object references. However, in our experience, it does not find non-existent links.

Once you have verified that there are no links in the formulas, you need to make sure that valid links are not hidden elsewhere. To do this, you need to start from the depths excel workbookscontaining non-existent links. Select the command Insert → Name → Assign (Insert → Name → Define). Scroll down the list of names by clicking and highlighting them in turn and looking at the formula in the Refers to box below. Make sure that none of the names refer to another workbook.

Instead of clicking all the names in a row in the Define Name dialog box, you can insert a new sheet into the workbook and select the menu item Insert → Name → Paste (Insert → Name → Paste). Then, in the Paste Name dialog box, click the Paste Link button. A list of all the names in your workbook will be generated, and the ranges they refer to will be listed in the appropriate column.


If any of the names point outside of your book, you will not find the source of at least one link, which will resolve the issue of updating. Now you must decide what to do: change the name of the range so that it refers only to this book, or leave the weight as it is.

Another possible source of links is yours. They may have the same problem we just looked at. It is necessary to check that all data ranges and X-axis labels of the chart do not refer to external books... Once again, it's up to you to decide if the links found are correct.

Links are hidden in objects as well, such as text boxes, autoshapes, and so on. Objects can link to external workbooks. The easiest way to find objects is to select any cell in the worksheet and then select the Edit → Go To command. In the Go To dialog box, click the Special button, check the Objects box and click the OK button. All objects on the sheet are selected. This should be done on a copy of your workbook. When all objects are selected, you can delete, save, close and reopen your copy to check if the problem is resolved.

Now that you've eliminated the possibility of real links appearing, it's time to remove the nonexistent ones. Open a workbook with non-existent links and choose Edit → Links. Sometimes you can just highlight the unnecessary link, click the Change Source button and associate the link with itself. But most often a message appears that one of the formulas contains an error, and this cannot be done.

If you can't use the simple method, notice where Excel thinks the link is (we'll call this a good workbook).

Create a real link between two books by opening both. Go to the problem book and enter \u003d in any cell of any sheet. Now click any cell in a good book and press Enter to create a real xref to another book. Save both books, but don't close them. In a workbook with non-existent links, choose Edit → Links and click the Change Source button to see all the links to the new workbook that you just intentionally created a new link to. Save your workbook again and delete the cell where you created the real xref. And save the file again.

This often removes an unnecessary, non-existent link as Excel finally realizes that you have removed the xref to the workbook. If the problem is still not resolved, try the following, but save a copy of the workbook first.

The next process involves permanently deleting data. Thus, before you start, create backup your book. If you do not do this, problems may arise.


In an open problem book, delete one sheet, save the workbook, then close and reopen it. If you do not see a prompt to update missing links, then the deleted sheet contained a non-existent link. The problem should now be resolved. However, if this is not the case, repeat the first step for each sheet in the workbook. You will need to add a new sheet before deleting the last one, since there must be at least one sheet in the workbook.

We continue on the assumption that this technique worked for you. Here's what to do next. Open a copy of your workbook (the one that contains all the data) and make another copy. You will work with the problem sheet (or sheets) and follow the removal process to discover where the problem is hiding on the sheet.

With the problem sheet open, select a range of cells (an area of \u200b\u200bapproximately 10 x 10 cells) and then select the command Edit → Clear → All. (Are you sure you kept a copy of the book?) Save, close and reopen the sheet. If you are not prompted to update links, you have found a problem and now you need to redo this block of cells. If the prompt is open, keep clearing cells until the next time you open the prompt. After that, change the problem cells.

We hope these tricks save you the time and hassle of spending those unfortunate non-existent workbook references. These are not the easiest and most pleasant solutions, but they will allow you to forget about the problems.

There are many stories and legends that there is a non-existent page in Odnoklassniki. Fortunately, some myths have been dispelled. First of all, it is safe to say that there are many such pages. But why and how they are created is still unknown. Let's try to understand this issue.

Search

It is quite easy to find such pages on the networks, for this you need to enter an ID in the address bar with the website, which does not exist at all. Let's try to find out why a non-existent page in Odnoklassniki was created.

One answer is maddeningly simple. In this social project there is a tab "My achievements", it has a certain point. It identifies a special assignment worth five hundred CP. This mission is called "Rare Find", and in order to complete it, a non-existent page in Odnoklassniki must be "caught". There are also other rewards, for which you can buy quite good bonuses and incentives at the auction.

Links to similar pages

What does a non-existent page on Odnoklassniki look like? Link - http://ok.ru/000. After walking along it, you can see the inscription that given address not on the site. But also under this message there may be helpful information... In our case, this is a reminder of the Great Patriotic Warand also that seventy years have passed since the victory.

Alternatively, you can go to interesting group or a page in Odnoklassniki. Entering random combinations, you can get to the page interesting person... If the above information did not help, then there is another answer to the question of where the non-existent page is in Odnoklassniki. To search for it, you should enter any number after ".ru /". Thus, you will definitely encounter the described phenomenon.

What does it give us?

For such a find, you get points, which you can then exchange for certain services from the site. Find on Odnoklassniki non-existent pageand get a lot of exciting bonuses. Most importantly, you'll get a badge in missions. You also get special points that can be exchanged at auctions.

More about prizes

On the Odnoklassniki website there is an opportunity to earn special project functionality. The developers have launched a special auction for regular visitors to social networks, where you can use points to buy yourself "invisible" for seven or five days. It is also possible to put the maximum rating under any photo or video you like.

How to quickly and effectively wind up your glasses

To receive such a bonus currency, you need to complete simple tasks that are in the "More" tab, in the "Achievements" section. By clicking on this function, you will see the entire list of missions, by completing which you can get special points. Their number depends on the complexity of the task. To receive the medal "True Fan", you must subscribe to the news of any pop or movie star in "Odnoklassniki". You need to submit an application for at least five verified pages, and if you unsubscribe from them, the medal will not disappear anywhere. The mission "Rare Find" is extremely easy.

To receive the regalia, you must go to the address marked “Non-existent page in Odnoklassniki”. Copy this link and paste into the address bar for input in your browser: www.odnoklassniki.ru/auctions/1. In this case, the last digit can be changed to any hieroglyph. In this case, when you click on the link, you will be shown information that this page is not on Odnoklassniki.

It is very easy to get the medal "How Smeared With Honey". For this it is necessary that friends often visit your page. The medal "Come in, do not hesitate" is similar in complexity to the previous one. "Leo Tolstoy" is a regalia for which a certain time is allocated. You need to change your status for seven days in a row.

From the start

To make the search for non-existent pages in Odnoklassniki even faster, and you don't have to reopen the site every time, this social network can be set as home page on your browser. To do this, let's make some settings. The procedure may vary depending on the browser you are currently using.

The most common browsers, except Internet Explorer, which is installed in Windows by default, are the following: Opera, Mozilla Firefox and Chrome. In order to start the settings of the latter, you should click on the icon, which has three horizontal stripes. This is where the "Parameters" item is located in a special drop-down menu. In the "Basic" section, select the "Initial group" function, specify the address in a special field social network "Classmates". Now you do not have to search for it through search engines every time before entering your favorite site.

fb.ru

Achievements in Odnoklassniki: what is and how to get

Achievements are rewards earned by users for being active on the Odnoklassniki.ru social network site.

By completing various tasks, the user receives achievements and points. These glasses he can spend on the purchase of various paid services at the auction in Odnoklassniki.

For example, for points you can buy:

  1. Rating "5+";
  2. "Invisible";
  3. "Smilies";
  4. "Presents".

You can enter the "Achievements" section by clicking on the "More" button in the menu, as shown in the screenshot below.

How to complete achievements in Odnoklassniki

Achievement "True fan" in Odnoklassniki

To complete the task "A real fan" in Odnoklassniki you need to subscribe to the pages of five "Stars". To make it easier for you, here are 5 pages:

You need to go to each of the pages and click the "Subscribe" button under the photo.

After the achievement is received, you can unsubscribe from these pages.

Achievement "Rare find" in Odnoklassniki

To make the achievement "Rare find" you need to find a non-existent page in Odnoklassniki. Simply put - a 404 page.

To earn this achievement, simply follow the link: https://ok.ru/404.

ok-gid.ru

How to find a non-existent page on Odnoklassniki

Hello, friends! Unlike other social networks, on Odnoklassniki, when performing various actions, you can get the corresponding achievements. There is nothing difficult in completing the tasks - you need to upload a photo, add a video, give marks, comment on entries, and more.

But some users are confused by the achievement called "Rare find" - you need to go to a non-existent page in Odnoklassniki. So let's figure out how to do it.

Achievement - A rare find in Odnoklassniki

First, let's talk about what “Achievements” are. You can find this menu item while on your page and clicking on the "More" button.

Various icons will be shown in the My Achievements tab. If the icon is gray, it means that you have not yet met the required condition. When you hover the mouse cursor over any icon, a task to be performed will be shown in a pop-up window.

After you complete the task, the icon turns color and you are awarded a certain amount of bonuses.

The "Rare find" icon is located in the "Missions" section, and to get it, you need to go to a page in Odnoklassniki that does not exist. For completing this task, you will be awarded 500 points.

Why do such tasks and get badges? - you ask. It's pretty simple. The number of accumulated points can be viewed at the top right. There is also a button "Auctions". By clicking on it, you will go to the page with auctions, where you can exchange the points you received for paid functions in Odnoklassniki: gifts, invisibility, rating 5+.

Link to a non-existent page

Now let's figure out how you can find a non-existent page on Odnoklassniki to get a badge and glasses.

To do this, you need to go to an address that is simply not in Odnoklassniki: in the address bar after ok.ru, type various numbers to get something like - https://ok.ru/12345678912345.

Let's take a closer look. Open your profile on Odnoklassniki and pay attention to the address bar of the browser.

Place the cursor in the address field, delete the word feed, and type in the numbers. I just added the letter s. Then press Enter.

As a result, you will go to the address that you entered, and if such a page does not exist, you will see a page with text, which is shown in the screenshot below.

So, in just a couple of clicks, we went to a non-existent page in Odnoklassniki. Hope it worked out and you got your badge and extra points!

inetfishki.ru

What does it mean to find a page that is not in the "classmates"? get a reward of 500 points for this - Club of the Odnoklassniki.ru site

Recently one of the most enviable bachelors, TV presenter Dmitry Dibrov, lost this seductive ... Read more »

This news is news only for those who do not work in the special services. And for those whose professional ... Read more »

Once Vladimir Vladimirovich ™ Putin walked along the long Kremlin corridors. It was piercing ... Read more »

In the nineties, the game was popular - "through how many people do you know ... Read more"

This week "Company Kvariani" applied for registration of the trademark "Odnoklassniki" ... Read more "

Another revolution is brewing on the Internet. A Google employee promises to create it ... Read more "

A lot of people are registered in this social network and each of them owns their own account, social circle, is in interest groups and is subscribed to the pages they like. It is very easy to get lost among so many users, especially for those of you who have not yet fully figured out ok.ru. If you are asking yourself the question: “How to find my page in Odnoklassniki by last name or phone number?”, Then this article is definitely for you. Naturally, the procedure will be completely free. Also, we do not need either Yandex or Google.

How to find your page and get to it

So, let's go directly to the search instructions. But how will we do it different ways, we will display each of them in a separate section. For your convenience.

What to do if authorization is reset?

This situation can happen for various reasons. Here is some of them:

  • the operating system has been reinstalled;
  • someone else was using your browser and logged out of your account;
  • browser crash;
  • changing the browser to another;
  • buying another computer or laptop.

So, let's figure out how to find your page and restore access to it:

  1. Go to Odnoklassniki through a friend's profile and enter in search string, which is located in the upper right half of the screen, the first and last name of your lost account. After the data is specified, press Enter or the magnifying glass icon.

  1. The next step is to switch the search mode to the "People" tab. If the result is not found immediately, then you need to use the filter from the right sidebar and look through the list in search of your page. When you find it, go to your profile by simply clicking on the photo.

Done! Here is the account you were looking for. We need to copy the user ID through which it will be possible to restore the page. But then another question arises - how do you find out the login from her? We will talk about this below.

Restoring access to your account

If you accidentally logged out of your account and now you cannot re-authorize or, in general, forgot your password - it doesn't matter, the situation is easy to fix. You can easily find your page on Odnoklassniki by the phone number that, at one time, indicated during registration. Here's how you can do it:

  1. On the initial login page, in the authorization form, click on the link. We marked it in the screenshot.

  1. Choose a password recovery method from the options shown in the picture. For our example, a phone number will be used. If you do not remember your username, select the item "Profile link".

  1. Enter your number and select a recovery method. You will receive either an SMS or a letter to email addressthat is linked to the account.

  1. Next, enter the confirmation code that came to your mobile, and click "Confirm".

  1. Introduce new password (and remember it well). Then click “Save”.

That's all. Access to the page will be restored, and you will see it on your screens.

Save your username and new password so that you don't lose them again. It may be best to write the data down on paper.

Search and restore a page by phone number

Now let's figure out how to find and restore our profile on the phone. We will use the Odnoklassniki app - in mobile version everything happens in a similar way.

So, in order to find your page through the phone, we do the following:

  1. Open the Odnoklassniki app and tap on the item indicated in the screenshot.

  1. In the pop-up window, click.

  1. To find your account, and then restore access to it, select the tile with the name "Profile ID".

  1. Next, we need to enter our ID. You can find it by going to your own page from the profile of a person you have as friends or by using the search. These are the numbers that come after https://ok.ru/profile/. In our case, Enter them in the field marked with an arrow "1", and click "Search".

  1. Then we make sure that the search returned our email (she is also a login), and we tap on "Continue".

  1. Open e-mail and copy the code that was sent to us from ok.ru.

  1. Enter the number in the field in the next step, then click "Confirm Code".

  1. Done. Our profile has been restored. It remains only to enter a new password and write it down so as not to lose it in the future.

After that, access to OK will be restored, and home page will be in front of us.

Naturally, it will not work to find a non-existent page on the Odnoklassniki social network.

Summary and comments

That's all. We figured out how to find your page in classmates and restore access to it. If you have any questions, feel free to ask them in the comments. We, in turn, are committed to helping everyone.

Video

For fans of visual manuals, there is a video tutorial on how to solve the described problem.

- The expired storage period of the uploaded file on the file hosting service

- Changing the structure of the blog / site

- Changing the addresses of pages on the site or the introduction of CNC

- Changed the addresses of the pages of the sites to which you link

In the process of such changes, dozens of non-existent pages may arise, to which your resource will link.

It is easy to find such non-existent pages. It is enough to know several services and be able to use them.

We will consider the 4 main methods of checking a site for broken links, and which one to use for yourself you will already decide for yourself.

On-line services for checking broken links:

I found many different services on the network, but I can only recommend 2 that really identify problem links qualitatively:

creatingonline.com

anybrowser.com

I will not describe the principle of their work, everything is very simple here. Type the url you are interested in into the form for verification and press the button for verification. After a certain period of time has elapsed, a page with the verification results will appear.

Using Yandex

IN webmaster panels follow the path - - Excluded pages and follow the link HTTP status: Resource not found (404). The screenshot shows the path.

After you have followed the link, a window will open, at the bottom of which there will be a list of links to nonexistent pages from your site. In the same window there will be information about last visit robot pages and links to problem pages indicated by a small square with an arrow pointing down. Now you need to follow these links and fix the situation.

Using Google

Similarly, we pass authorization in webmaster panels and follow the path - Scanning - Scanning errors. In the lower half of the page, we see a list of links to non-existent pages. There is one great option in the Google webmasters panel that allows you to mark links that you have corrected to non-existent pages. I showed her to.

Xenu Link Sleuth Program

Follow the link and download program. Then we install it. At the end of the installation, launch the program and fill in the address of the checked resource. Click the OK button, and the program starts collecting information.

Busy - queued for verification.

After the end of the collection of information, the program will sound signal completion of work, and you can view the report on the work performed. Highly good program, I use it constantly.

And the last method we'll look at is checking the site for broken links using the Broken Link Checker plugin.

For this download the plugin, activate it and go to the address - Options - Check links and go to the Advanced tab in which we click Recheck all pages.

If you have a large site with a large number of pages, then the search engine promotion of such a project often comes down to identifying and eliminating many technical problems.

One of the common mistakes is the presence of broken links to pages with the response code “404 not found". Moreover, links from other sites can lead to pages with 404 errors, and their weight will be lost. In this article, you will learn how to get back the lost external link weight.

“I can tell you for sure that something breaks all the time on a more or less large site”
- Mikhail Slivinsky (Wikimart.ru), SEO Conference 2014.

Method essence

Links from other sites do not transfer weight if they lead to broken pages on your site. The task is to set up a redirect (301 redirect) from non-existent pages with incoming links to other suitable pages on the site. Thus, the weight of incoming external links will begin to be transferred to the site.

This method is more suitable for projects with age and a large number of pages. The work algorithm is as follows:

1. Search and list of 404 error pages.
2. Checking the received url-addresses for the presence of incoming external links.
3. Installation of 301 redirects from broken pages to suitable work pages.

How to find 404 error pages and other broken pages

At this stage, you need to identify non-existent pages, pages with errors on the site and make a list of urls as detailed as possible. There are several tools for this, which will be discussed in detail below.

Yandex.Webmaster and Google Webmaster Tools panels

If your site has not yet been added to the Yandex and Google webmaster panels, be sure to add it now. This way, you can identify broken links and other indexing errors in a timely manner.

To get a list of pages with 404 errors in the Yandex.Webmaster panel, go to http://webmaster.yandex.ru/sites/ in the "Site indexing" → "Excluded pages" section.


(click on the image to enlarge)

To get a list of nonexistent pages from the Google Webmaster Tools panel ( https://www.google.com/webmasters/tools/) go to the link "Scanning errors".

(click on the image to enlarge)

The page will list the urls with errors. You can export the list by clicking the Download button and choosing a convenient upload format.

(click on the image to enlarge)

Crawler programs

Here you can highlight famous programs to find broken links and duplicates:

All of them allow you to find on the site and download a list of 404 error pages. For these purposes I use Screaming Frog Seo Spider, as it has a Mac version, unlike the others. Using the Screaming Frog example, a list of 404 pages is downloaded like this:

(click on the image to enlarge)

Server error log

If possible, it is worth looking at the server error log. This is usually the "error_log" file. Depending on the software used on the server, the error log may differ. But the essence is still the same - to view the server error log and unload the list of urls with 404 errors from it.

The resulting lists of links must be combined into one list and duplicates removed. There are many ways to do this, but I am using text editor Sublime Text 2 (on Windows I recommend Notepad ++ with the TextFX plugin).

(click on the image to enlarge)

Checking the list of broken pages for incoming links

To check the final list of urls for incoming links from other sites, the Ahrefs.com service is used, namely the Batch Analysis section - https://ahrefs.com/labs/batch-analysis/.

(click on the image to enlarge)

Unfortunately, this function has a limitation of 200 url per 1 request for paid plans and 2 url per 1 request for free. Therefore, you need to drive your list into several portions of 200 addresses. After each check, you need to export to a file.

(click on the image to enlarge)

The resulting unloadings of 200 url must be combined into 1 table. To do this, you need to open 1 file and copy the contents of other files to the end. Extra columns can be deleted. We are only interested in the "Total" column, it means the total number of external links to the page.

(click on the image to enlarge)

The resulting list must be sorted and the lines in which "Total" is equal to zero must be removed. As a result, you will get a list of broken pages that have incoming links from other sites.

Selection of pages for redirection

The resulting list needs to be uploaded to Batch Analysis on Ahrefs again so that you can see from which sites and with which anchors there are links to each page of our list. To do this, use the icon next to the url-address.

(click on the image to enlarge)

Next, you need to look from which pages and with which anchors external sites linked. For convenience, create a table with two columns, which will contain a list of broken addresses and a list of "live" addresses to which the redirect will go. If the url of the page on your site just changed, then enter the new url of the page. Otherwise, select the most relevant page in your opinion, based on the text of the donor page and the anchor.

(click on the image to enlarge)

Setting up 301 redirects to new pages

At the end, it remains to add the necessary commands for .htaccess to the file. To redirect from one page to another, use the following command:

For each address of the final table, you need to write such a command and add it to the ".htaccess" file. At this stage, I recommend using the services of a programmer to get everything working properly.

As a result, we will get link weight for free, simply by not losing it.

Did you like the article? To share with friends: