Question about Microsoft Excel for PC

1 Answer

What does the [Group] tag next to the filename mean?

Recently, when I open some excel files the tag (i don't know the technical name for it) appears next to the filename. These files have never had that tag before and now I am unable to edit the worksheet without random cells or columns disappearing. Could you tell me how to remove this tag? Many thanks.

Posted by on

  • Lampedusa Jan 10, 2008

    teglmh: thank you for your solution. The [Group] 'tag' for want of a better name looked like this: accounts.xls [Group]

    I am sure i saved the files as normal .xls files, so I was wondering where the [Group] bit came from. I have tried scanning for a virus and the virus checker couldn't find any viruses.

  • Lampedusa Jan 10, 2008

    thanks teglmh, i tried your suggestion but it did not work. However, i have been informed that the [Group] tag comes on when the woksheets are grouped. I don't know how they got grouped, but i have managed to ungroup them by right clicking on a worksheet tab and selecting ungroup.



    Thank you very much for spending time trying to solve this problem.

×

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

    Scholar:

    An expert who has written 20 answers of more than 400 characters.

  • Expert
  • 146 Answers

You may have picked up some malware, by "tag" do you mean the file extension eg accounts.xls ?
I would strongly advise running an anti-virus scan as some malware can hide in Excel, especially if there are macros.

Please post back and us know what happens.

Posted on Jan 09, 2008

  • martin hogg Jan 10, 2008

    thanks for the additional info, it may be worth trying to re-name the file, ie highlight it, right click, select re-name and give it another name eg accounts2.xls but without the group tag then select "open with" and chose ms excel from the clean list.

    or use "save as" to create a copy to play safely with.

×

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

How do I open an .xls file in 64-bit version of excel without it being in protected view?


I was like that when the problem exists when double-clicking in Windows Explorer. Then I get the message that the program isn't responding and have the option to close or wait. After a few moments Excel does eventually open and I can work on the file. I do not have the problem when I open the file directly form Excel.
Read here, perhaps this article will help you - Excel Restore Toolbox http://www.excel.restoretools.com/

Apr 25, 2015 | Microsoft Excel for PC

1 Answer

Hyperlink other document in excel button


The easy way (but labor intensive) is to put the file names in a column (can be any name you want or the pdf file name), right click on a cell, hit insert hyperlink, and in the address field at bottom, put in the file pdf file name. You would have to do this for each of your 100 files.

If you want to automate it, create a column with the directory path name, a 2nd column with the full file names, a 3rd column where you concatenate the two previous columns to create the full path, and then use the hyperlink command to provide the link:


Folder name Filename Concatenated LINK ../excel/ file1.pdf ../excel/file1.pdf file1.pdf ../excel/ file2.pdf ../excel/file2.pdf file2.pdf ../excel/ file3.pdf ../excel/file3.pdf file3.pdf

Here are the formulas behind this:
A B C D Folder name Filename Concatenated LINK ../excel/ file1.pdf =CONCATENATE(A2,B2) =HYPERLINK((C2),B2)
../excel/ file2.pdf =CONCATENATE(A3,B3) =HYPERLINK((C3),B3)
../excel/ file3.pdf =CONCATENATE(A4,B4) =HYPERLINK((C4),B4)
This should work like a charm and the other advantage is that excel won't rename your path locally depending on weather a file is open or not).

Feb 21, 2014 | Microsoft Excel for PC

1 Answer

I accidently formatted my Buffalo Ministation HDD, is there a way to fix it?


There are a few ways to undelete files after formating a Hard drive or deleting files, however note that while you might not be able to restore 100% of your files, you should be able to retrieve a few critical files or pictures.

It is important to not write any files to the hard drive at this time.
Writing files to your Hard Drive after deleting files or formatting a hard drive will reduce the amount of files you can recover. Since the Buffalo Ministation is an external hard drive, the process becomes easier than if this were an internal drive.

First off, plug the Buffalo Ministation into any USB port into your computer. Second, download Recuva. (Recuva is a free software that helps recover deleted files.) Install Recuva.

1) Close all other programs
2) Open Recuva
3) The Recuva Wizard will now appear. Click Next
4) You can now choose which file type you want to recover. Music files, image files, any files , etc. Click next when you made your choice.
5) Now you have to choose the location of the external Hard drive. If you don't know which drive letter is assigned to the the external hard drive, choose "On my media card or iPod". This will scan all external drives and devices. Alternatively, you can go to the start menu and click "My computer". When the my computer window shows up, you will see your external hard drive and a drive letter. Once you find what the drive letter is, go back to recuva and choose "In a specific location". Then click the Browse button and click the drive letter assigned to your external drive. Click next.

6) Click next on this final window.
7) The scan will now begin. Wait until the scan is over. Once the scan has completed, a list of files and their file names will appear. Next to the Filenames are icons with different colors. These colors indicate the state of the deleted file, and how well the restored condition will be. Green means the file will be perfectly intact, orange means there might be some corruption, red generally means the file may not be recovered. At this point in time you can choose which files you would like to recover. If you want to attempt to recover all files, click the the check box right next to the Filename box.

8) When you have finished selecting your files to recover, click "Recover" towards the lower right corner of the screen.
9) A box asking where you want to send the recovered files will appear. Click Desktop and make a new folder there. Call it what ever you want. Select the folder and click OK.
10) When the operation is done, a dialog box will appear telling you how long it took.
11) Check the files you have just recovered in the folder you made on the desktop

Voila, your files should be ready to be viewed. If there were files you wanted to recover that did not show up the first time, go back to step 6 and click "Deep Scan". That will take a lot longer, but should find files that did not appear before. Follow the rest of the guide as normal from step 6 onwards.

Sep 14, 2013 | Buffalo Technology Computers & Internet

4 Answers

How to convert 2007 excel sheet into 2003 excel sheet


if you have excel 2007 you can save the file into excel 2003 compatibility

if you have excel 2003 need download compatibility pack from this page
http://www.microsoft.com/downloads/en/details.aspx?familyid=941b3470-3ae9-4aee-8f43-c6bb74cd1466&displaylang=en
install it and success!

Feb 22, 2011 | Computers & Internet

2 Answers

My file is in excel 2007 i want to open in excel 2003 how would it happen or not


open the excel 2007 file in excel 2007 only and save as file.xls[xls is a 2003 version]

with this method u can open it though excel 2003
any issues kindly rate and revert

Jul 14, 2010 | Microsoft Excel 2007 Home and Student...

1 Answer

CD html presentation-hyperlinks don't work with other pc's


To create an Autorun-enabled CD-ROM, proceed as follows:
  • Create an Autorun.inf File
    Autorun.inf is a text file that is located in the root folder of your application CD-ROM. It provides to the computer the name and the location of the startup program for your application that is installed when the CD-ROM is inserted. The Autorun.inf file can also contain optional information including the following:
  • The name of a file that contains an icon that represents your application's CD-ROM drive. This icon appears in Windows Explorer instead of the standard drive icon.
  • Additional commands for the shortcut menu that appears when the user right-clicks the CD-ROM icon. You can also specify the default command that runs when the user double-clicks the icon. Autorun.inf files are similar to .ini files.
  • The [autorun] section contains the default Autorun commands. All Autorun.inf files must have an [autorun] section.
  • icon: Specifies the path and the file name of an application-specific icon for the CD-ROM drive.
  • open: Specifies the path and the file name of the startup application.

Autorun.infThe following is an example of a simple Autorun.inf file. It specifies Filename.exe as the startup application. The second icon represents the CD-ROM drive instead of the standard drive icon.
[autorun]
open=Filename.exe
icon=Filename.ico

May 07, 2009 | Dell Dimension 4600 PC Desktop

2 Answers

Lotus notes archives not appearing on the workspace


This problem tends to happen if something is wrong with your desktop.ndk (might be desktop7.ndk) document, you can find that in the notes folder or in the data subfolder, but you can search for it. Shut down lotus, rename the file, start lotus again. It will create a new desktop file. The backside is that you will loose all your bookmarks, but on the new desktop you can add the archives.

Let me know if it worked and rate my solutions pls

Feb 09, 2009 | IBM Computers & Internet

1 Answer

Importing from excel


go to file in the outlook.
click on import and export
select import from another program of file, click next
select Microsoft Excel 97-2003, click next
type in or browser for the Excel file you want to import, and select don not import duplicate items. click next
select destination folder-contact folder click next
***********To add or remove fields to determine the way the contact information is saved in the new imported file,***********
click on map custom field.
click and drag the item in the left panel to the right panel, where you want the item to appear.
click finish.
if you don't like the way the items imported. just hight all of the items that was imported in the contact folder and press deleted.
you can start again.

if you still have problem. go to the follwoing link
http://office.microsoft.com/en-us/outlook/HA010964231033.aspx

Dec 18, 2008 | Microsoft Office Outlook 2003 for PC

1 Answer

How do you set the image's filename to automatically include timestamp and date


Dear jeannesc:

I am assuming that you are using ZoomBrowser EX ver 5.8 which comes with the SD750's Digital Camera Solutions disc. Therefore these instruction will pertain to that version of the program.

You can rename image files using four different naming schemes:

1. Image Name + Number (e.g. Vacation_001.jpg)
2. Shooting date + Number (e.g. 20080601_001.jpg)
3. Name + Shooting date + Number OR
4. Shooting date + Name + Number

There isn't a provision for a time stamp naming convention.

To rename a group of images using one of the above naming schemes simply open ZoomBrowser and point it to the folder that contains the images you wish to rename. For this example let's assume it was your recent vacation photos.

I would utilize either Zoom or Scroll mode to view the images on the main screen. Then follow these steps:

1. Click the task panel labeled "View & Classify"
2. Next click the sub panel "Rename Multiple Files"
3. On the left hand panel click Step 1 "Select images"
[Here you can select any or all images in the folder]
4. Next click Step 2 "Specify Rename Settings"
5. Select the way you want the files to be named and enter
the appropriate settings. Note: If you wish to keep the original
file and make a copy with the new naming scheme make
sure you check "Make Copies of files"
6. Lastly click Finish and your newly renamed files will be there
in the folder.

Hopes this helps.

Sincerely,
HeavyDLB

Jun 01, 2008 | Canon PowerShot SD750 / IXUS 75 Digital...

3 Answers

System not booting


take windows xp cd and repair from the cd

Sep 01, 2007 | Microsoft Windows XP Professional With...

Not finding what you are looking for?

Open Questions:

See all Microsoft Excel for PC Questions

Microsoft Excel for PC Logo

65 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2993 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18424 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...