Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: excel has gone mad

07 Mar 2010   #1

windows 7 Home premium 32 bit
excel has gone mad


Ok. God knows what has happen or what setting has changed

I have 2 excel spreadsheets. I use one to index the other and pull information into it.

For some unknown reason excel has stated doing this appdata thing.

The formula use to look like this

=INDEX('[DAILY SORTING OF DATA.xlt]WATCH '!$A$4:$M$1840,MATCH(A3:A1840,'[DAILY SORTING OF DATA.xlt]WATCH '!$A$4:$A$1840,0),11)

now it looks like this

=INDEX('C:\Users\Vic\AppData\Local\Temp\[DAILY SORTING OF DATA1.xlsx]DATA'!$A$2:$M$6000,MATCH(A$2:A$2493,'C:\Users\Vic\AppData\Local\Temp\[DAILY SORTING OF DATA1.xlsx]DATA'!$A$2:$A$6000,0),11)

(yes i know they are 2 different formulas- one is the original from a note pad- but that sheet doesn't work at all now either)

I can't remove the appdata bit from the formula.

I have tried redoing the sheet. It doesn't pull any data at all.

any ideas

My System SpecsSystem Spec
12 Mar 2010   #2

Windows10 Pro - 64Bit vs.10547

are you running and saving two separate sheets..?

if so, try running them both in the same sheet via the tabs at the bottom of the screen
you can copy/paste the index to the new tab..
My System SpecsSystem Spec
13 Mar 2010   #3

windows 7 Home premium 32 bit

thank BugMeister

it is 2 separate sheets. I worked it out.

I had a back up in my sky drive. I brought then both down and then did a re- link. I have lost a little data but i can live with that

To re link

go to data ---- then edit links and change the connection.

note: ms words asked to re-link the documents as soon as i opened them.

thanks for your help BugMeister
My System SpecsSystem Spec


 excel has gone mad

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Similar help and support threads
Thread Forum
How to go back from Excel 2010 64 bit to Excel 2010 32 bit
I have an important program that uses a DLL that only works with Excel 2010 32 bit. I'm running Excel 2010 64 bit now -- how do I install the 32 bit version? I have the CD which has both versions on it. But when I run Setup, it gives me options that I don't understand for this limited purpose. In...
Microsoft Office
Excel And .CSV ?
Hello, I have created a small Excel file that I wish to be saved as a CSV. Question: do I have to put " marks around the beginning, and end, of the text in each cell, or does Excel automatically do what is required for CSV when I tell it to Save As a CSV ? I did Not put any " marks around...
Microsoft Office
Formatting Excel 2010, Excel 2003
Hello, I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns. It's a cinch when...
Microsoft Office
Hi, Maybe a bit of off-forum, but how do you make that column A en B show on every sheet (not printed) of my excel workbook? I got Name and First Name, and I want to have that shown at every new sheet I make without having it to copy each time and when I change something at my first sheet, the...
Can't open 2003 Excel Files in Excel 2007?
I'm not sure if it because the files are 2003 or not? When I try to open them an error message appears stating, "...the file you are trying to open is in a different format than specified by the file extension. Verify file is not corrupted and is from a trusted source..." These are my files. The...
Microsoft Office
Excel 2003 - Multiple Excel Open
Hi All, I don't know if I'm posting in the right area but I really need help. Before (In XP and Vista), when I have one excel file open and I go to desktop to open a different excel, it would open in the same excel program (2 files in 1 program) With Windows 7, when I open a different file, it...
Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 02:17.

Twitter Facebook Google+

Windows 7 Forums

Seven Forums Android App Seven Forums IOS App